Adding values per unique customer together with sumif

Question

I have a list of customers and values looking something like this

JeffJohnson, Coke, 2.5
JeffJohnson, Sandwich, 6
JennyWilson, Donut, 3

What I want is a list of total by customer looking like this

JeffJohnson, 8.5
JeffJohson, 8.5
JennyWilson, 3

I tried using =sumif (a:a, b1, c:c) but it is not working. I need it to work for quite a few lines without manually adding the query.

Any ideas?

Answer 1

Your SUMIF() criteria need to change to A1 instead of B1. See below

=SUMIF(A:A,A1,C:C)