Thanx for the assistance.

This worked for me - =SUMIF(A:A,"John Doe",B:B)

This didn't -
=sumproduct(--(A1:A500)="John Doe"),--(B1:B100))

If "John Doe" is in a cell e.g C1, then replace literal by cell

=sumproduct(--(A1:A500)=C1),--(B1:B100))

When I used these, I kept getting the #VALUE! error. My list of names
is in A2:A60, the corresponding numbers are in B2:B60.

I'm using Excel 2003.

Thanx


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=546477