Sum only specified values

[Bob]

Column A Column B
Joe 100
John 300
Bob 200
George 500
John 300
Bob 250
John 125

How do I get the sum of all entries for John in a cell in Column C?

 

[T. Valko]

Try this:

=SUMIF(A1:A7,"John",B1:B7)

Or, use a cell to hold the criteria:

D1 = John

=SUMIF(A1:A7,D1,B1:B7)

 

[Bob]

Thanks, that did it!

Try this:

=SUMIF(A1:A7,"John",B1:B7)

Or, use a cell to hold the criteria:

D1 = John

=SUMIF(A1:A7,D1,B1:B7)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks, that did it!