Try this:

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

Or, use a cell to hold the criteria:

D1 = John

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


--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
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?