sum up total baed on names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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
 
That's what I showed you

--

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
 
Back
Top