Counting only the "right" activities

K

Kreller

I'm making a timeregistration-sheet for work. I have set up the shee
very simply - each row is a date in a month and for each date I hav
set up three sets of cols with "time" and "activity" so that when
registrate my time I choose X hours in col b and the activity I hav
used X hours on (defined from a list with 9 different task types) i
col c. This works allright - simple but whatever.

Now I want to sum up how many hours I for the whole month have spent o
one of the 9 task types and run into problems finding the prope
formula. Basically I tried with "=SUMIF(C3;"Task 1
administration";B3)" and just added sumif's like "=SUMIF(C3;"Task 1
administration";B3)+SUMIF(C4;"Task 1 - administration";B4)". This i
not pretty when keeping in mind that there are 31 days in October an
three cols to sumif from. It will be a very long formula! And prett
boring to write and even more boring to update later. Do you have
suggestion as to how I can sum up all the hours I have spent on each o
the nine activities?
 
A

Alex Delamain

Try using Sumproduct()

=sumproduct((b2:b32="administration")*(c2:c32))

you can also reference the task type to a cell with a drop down makin
selecting the task simpler.

Alternatively try a pivot table
 
Top