how to sum when two conditions are met, e.g. name and task number

[steve95959]

I have a spreadsheet in which I am keeping track of employee's hours worked
on individual tasks, so I need to sum cells by person and by task. can't
figure out how to say sum if "name" and "task #". Thanks for any help!

 

[Mike H]

Try this where Col A is the name, Col b is the task name or number and Col C
is the hours on that task

=SUMPRODUCT((A1:A20="Mike")*(B1:B20="Task 22")*(C1:C20))

Mike

 

[Bob Phillips]

=SUMPRODUCT(--($A$2:$A$200="name"),--($B$2:$B$200=task#),$C$2:$C$200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[steve95959]

Thank you tons Mike H and Bob Phillips! Both formulas work!