Finding total of one column while counting another

[dpwicz]

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

 

[FSt1]

hi
you would need 2 formulas both sumif.
1. =sumif(C2:C5,"Catagory A", D25)
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