Hi!

Try this:

Use a cell to hold the criteria:

C1 = Adam S Mower

Names in column A, amounts in column B.

=SUMIF(A1:A100,C1,B1:B100)

Biff

"ashstudly" wrote
in message ...

I can't believe how easy that was... I've tryingthat forever! Thank you
so much! Here is another one...This time summing up the total for each
person.

Supervisor Total
Adam S Mower 5.65
Adam S Mower 6.04
Adam S Mower 8.09
Adam S Mower 7.34
Candice S Carter 1.24
Candice S Carter
Candice S Carter 1.98
Chris S Uigaese 2.43
Chris S Uigaese 9.78
Chris S Uigaese 4.33
Chris S Uigaese
Chris S Uigaese 3.78


--
ashstudly
------------------------------------------------------------------------
ashstudly's Profile:
http://www.excelforum.com/member.php...o&userid=30720
View this thread: http://www.excelforum.com/showthread...hreadid=503907