PDA

View Full Version : Sumif formula



rahullambe
03-29-2010, 05:19 PM
Hi,

I have a spreadsheet of employee allocation towards the project, 1st column is for project name, 2nd for Category and 3rd for sub category of employee and then dates of allocation. (see attachment)

Also I have added resources category and subcategory wise report in the table. now I want total resources utilized on 1st date say 15th of March for Category 1 and subcategory1, then category 1 and subcategory 2 and so on by using formula.

Please help me..

Bob Phillips
03-30-2010, 02:04 AM
Is this what you mean?

=SUMPRODUCT(--($C$4:$C$16="Management"),--($D$4:$D$16="Technical"),$E$4:$E$16)