software

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,quot;Bobquot;,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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Syahiraquot; gt; wrote in message
...
gt; Let ay I have this table:
gt;
gt; Math Paper A
gt; Name Marks Total ( Paper A Paper B)
gt; Bob 92
gt; Debbie 72
gt; Carlos 63
gt;
gt; Math Paper B
gt; Name Marks
gt; Carlos 87
gt; Bob 56
gt; Debbie 50
gt;
gt; How do I total the marks let say for Bob? I know I just can add up the
gt; column but I want to add up by name. Thank you
how about if I want to add the total marks for Bob?

quot;Peo Sjoblomquot; wrote:

gt; =SUMIF(A:A,quot;Bobquot;,B:B)
gt;
gt; or better
gt;
gt; =SUMIF(A:A,C1,B:B)
gt;
gt; where you put the name you want to sum for in C1
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Syahiraquot; gt; wrote in message
gt; ...
gt; gt; Let ay I have this table:
gt; gt;
gt; gt; Math Paper A
gt; gt; Name Marks Total ( Paper A Paper B)
gt; gt; Bob 92
gt; gt; Debbie 72
gt; gt; Carlos 63
gt; gt;
gt; gt; Math Paper B
gt; gt; Name Marks
gt; gt; Carlos 87
gt; gt; Bob 56
gt; gt; Debbie 50
gt; gt;
gt; gt; How do I total the marks let say for Bob? I know I just can add up the
gt; gt; column but I want to add up by name. Thank you
gt;
gt;
gt;

That's what I showed you

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Syahiraquot; gt; wrote in message
...
gt; how about if I want to add the total marks for Bob?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; =SUMIF(A:A,quot;Bobquot;,B:B)
gt;gt;
gt;gt; or better
gt;gt;
gt;gt; =SUMIF(A:A,C1,B:B)
gt;gt;
gt;gt; where you put the name you want to sum for in C1
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Excel 95 - Excel 2007
gt;gt; Northwest Excel Solutions
gt;gt; www.nwexcelsolutions.com
gt;gt; quot;It is a good thing to follow the first law of holes;
gt;gt; if you are in one stop digging.quot; Lord Healey
gt;gt;
gt;gt;
gt;gt; quot;Syahiraquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Let ay I have this table:
gt;gt; gt;
gt;gt; gt; Math Paper A
gt;gt; gt; Name Marks Total ( Paper A Paper B)
gt;gt; gt; Bob 92
gt;gt; gt; Debbie 72
gt;gt; gt; Carlos 63
gt;gt; gt;
gt;gt; gt; Math Paper B
gt;gt; gt; Name Marks
gt;gt; gt; Carlos 87
gt;gt; gt; Bob 56
gt;gt; gt; Debbie 50
gt;gt; gt;
gt;gt; gt; How do I total the marks let say for Bob? I know I just can add up the
gt;gt; gt; column but I want to add up by name. Thank you
gt;gt;
gt;gt;
gt;gt;
Ok got it. Thank You (^_^)

quot;Peo Sjoblomquot; wrote:

gt; That's what I showed you
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Syahiraquot; gt; wrote in message
gt; ...
gt; gt; how about if I want to add the total marks for Bob?
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; =SUMIF(A:A,quot;Bobquot;,B:B)
gt; gt;gt;
gt; gt;gt; or better
gt; gt;gt;
gt; gt;gt; =SUMIF(A:A,C1,B:B)
gt; gt;gt;
gt; gt;gt; where you put the name you want to sum for in C1
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Excel 95 - Excel 2007
gt; gt;gt; Northwest Excel Solutions
gt; gt;gt; www.nwexcelsolutions.com
gt; gt;gt; quot;It is a good thing to follow the first law of holes;
gt; gt;gt; if you are in one stop digging.quot; Lord Healey
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Syahiraquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Let ay I have this table:
gt; gt;gt; gt;
gt; gt;gt; gt; Math Paper A
gt; gt;gt; gt; Name Marks Total ( Paper A Paper B)
gt; gt;gt; gt; Bob 92
gt; gt;gt; gt; Debbie 72
gt; gt;gt; gt; Carlos 63
gt; gt;gt; gt;
gt; gt;gt; gt; Math Paper B
gt; gt;gt; gt; Name Marks
gt; gt;gt; gt; Carlos 87
gt; gt;gt; gt; Bob 56
gt; gt;gt; gt; Debbie 50
gt; gt;gt; gt;
gt; gt;gt; gt; How do I total the marks let say for Bob? I know I just can add up the
gt; gt;gt; gt; column but I want to add up by name. Thank you
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

look in the help index for SUMIF

--
Don Guillett
SalesAid Software

quot;Syahiraquot; gt; wrote in message
...
gt; Let ay I have this table:
gt;
gt; Math Paper A
gt; Name Marks Total ( Paper A Paper B)
gt; Bob 92
gt; Debbie 72
gt; Carlos 63
gt;
gt; Math Paper B
gt; Name Marks
gt; Carlos 87
gt; Bob 56
gt; Debbie 50
gt;
gt; How do I total the marks let say for Bob? I know I just can add up the
gt; column but I want to add up by name. Thank you
Or use a drop down list in C1...

Syahira wrote:
gt; how about if I want to add the total marks for Bob?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; =SUMIF(A:A,quot;Bobquot;,B:B)
gt;gt;
gt;gt; or better
gt;gt;
gt;gt; =SUMIF(A:A,C1,B:B)
gt;gt;
gt;gt; where you put the name you want to sum for in C1
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Excel 95 - Excel 2007
gt;gt; Northwest Excel Solutions
gt;gt; www.nwexcelsolutions.com
gt;gt; quot;It is a good thing to follow the first law of holes;
gt;gt; if you are in one stop digging.quot; Lord Healey
gt;gt;
gt;gt;
gt;gt; quot;Syahiraquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Let ay I have this table:
gt;gt;gt;
gt;gt;gt; Math Paper A
gt;gt;gt; Name Marks Total ( Paper A Paper B)
gt;gt;gt; Bob 92
gt;gt;gt; Debbie 72
gt;gt;gt; Carlos 63
gt;gt;gt;
gt;gt;gt; Math Paper B
gt;gt;gt; Name Marks
gt;gt;gt; Carlos 87
gt;gt;gt; Bob 56
gt;gt;gt; Debbie 50
gt;gt;gt;
gt;gt;gt; How do I total the marks let say for Bob? I know I just can add up the
gt;gt;gt; column but I want to add up by name. Thank you
gt;gt;
gt;gt;