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

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!

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

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

"steve95959" wrote:

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!

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

=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" wrote in message
...
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!

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

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

"Mike H" wrote:

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

"steve95959" wrote:

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!