Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of weeks to complete a task | Excel Worksheet Functions | |||
Number of recently used templates on New Workbook task pane | Excel Discussion (Misc queries) | |||
Limit on number of conditions? | Excel Worksheet Functions | |||
Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions |