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. |
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. |
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. |
All times are GMT +1. The time now is 09:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com