Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total of one column while counting another
I have a table that contains names that have a time, category, the number of
times that the name uses the category, and the total time the name uses the category. What I want to do is get the total time for each category? There are about 3000 names and 10 categories. name A 5:00 category A 20 1:40:00 name B 3:30 category B 10 0:35:00 name C 4:21 category A 9 0:39:09 name D 4:49 category A 17 1:21:53 catagory A 46 ??:??:?? catagory B 10 0:35:00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total of one column while counting another
hi
you would need 2 formulas both sumif. 1. =sumif(C2:C5,"Catagory A", D2:D5) which equals 46 2. =sumif(C2:C5,"Catagory A", E2:E5) which equals 3:41:02 format the results of the second formula as time. Adjust ranges to suit. you would need a pair of the above formulas for each catagory. Regards FSt1 "dpwicz" wrote: I have a table that contains names that have a time, category, the number of times that the name uses the category, and the total time the name uses the category. What I want to do is get the total time for each category? There are about 3000 names and 10 categories. name A 5:00 category A 20 1:40:00 name B 3:30 category B 10 0:35:00 name C 4:21 category A 9 0:39:09 name D 4:49 category A 17 1:21:53 catagory A 46 ??:??:?? catagory B 10 0:35:00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding percents of a total | Excel Worksheet Functions | |||
need help finding string them averaging the total | Excel Discussion (Misc queries) | |||
Finding 'total' in range | Excel Worksheet Functions | |||
finding a range of dates to total | Excel Discussion (Misc queries) | |||
Finding combinations to match a total | Excel Discussion (Misc queries) |