sum up total baed on names

S

Syahira

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
 
P

Peo Sjoblom

=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
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VLOOKUP to Sum values from multiple columns 1
% of fixed sum in pivot table 2
multiple columns into one column and autofill(?) question 1
Look up values in multiple cells and sum 4
Sum up cells in column A that has same text in Column B. 4
Sum if another column matches 2
VBA for summing buys and sells 0
Average Offset 16

Top