Finding total of one column while counting another

D

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top