=SUMIF(A:A,"Bob",B:B)

or better

=SUMIF(A:A,C1,B:B)

where you put the name you want to sum for in C1

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Syahira" wrote in message
...
Let ay I have this table:

Math Paper A
Name Marks Total ( Paper A + Paper B)
Bob 92
Debbie 72
Carlos 63

Math Paper B
Name Marks
Carlos 87
Bob 56
Debbie 50

How do I total the marks let say for Bob? I know I just can add up the
column but I want to add up by name. Thank you