| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum up total baed on names
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total baed on names
=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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total based on names
how about if I want to add the total marks for Bob?
"Peo Sjoblom" wrote: =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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total based on names
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 "Syahira" wrote in message ... how about if I want to add the total marks for Bob? "Peo Sjoblom" wrote: =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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total based on names
Ok got it. Thank You (^_^)
"Peo Sjoblom" wrote: 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 "Syahira" wrote in message ... how about if I want to add the total marks for Bob? "Peo Sjoblom" wrote: =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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total based on names
Or use a drop down list in C1...
Syahira wrote: how about if I want to add the total marks for Bob? "Peo Sjoblom" wrote: =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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sum up total baed on names
look in the help index for SUMIF
-- Don Guillett SalesAid Software "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
| The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
| Copying a total from another Sheet | Excel Worksheet Functions | |||
| matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Hybrid Mode
