Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting and adding
good afternoon.
here is what im trying to do column A has 3 names in colum b there is a number for each name, i want to get the sum of the column b for the first name, then the sum of the second and so one A B john 15 jack 7 john 17 jill 9 jack 16 john 2 jill 11 jack 9 jill 2 thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting and adding
=SUMIF(A1:A10,"John",B1:B10)
Adjust as necessary. HTH, Paul "Isaiah I" <Isaiah wrote in message ... good afternoon. here is what im trying to do column A has 3 names in colum b there is a number for each name, i want to get the sum of the column b for the first name, then the sum of the second and so one A B john 15 jack 7 john 17 jill 9 jack 16 john 2 jill 11 jack 9 jill 2 thanks for the help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting and adding
try =SUMIF(A1:A6,"john",B1:B6) changing "john" as required
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Isaiah I" wrote: good afternoon. here is what im trying to do column A has 3 names in colum b there is a number for each name, i want to get the sum of the column b for the first name, then the sum of the second and so one A B john 15 jack 7 john 17 jill 9 jack 16 john 2 jill 11 jack 9 jill 2 thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding totals in a column, not counting repetitions in another col | Excel Discussion (Misc queries) | |||
Counting | Excel Worksheet Functions | |||
counting | New Users to Excel | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |