P
Paige
I have 2 worksheets, one with columns such as the person
assigned to a task and status of task. The other
worksheet is a summary tab. I want to know how many
tasks Mike has marked complete. Something like- add all
instances where A:A (being the resource column) is Mike
and D
(being the status column) is complete.
I know sumif and countif but I can't get them to work
with multiple conditions.
Please help!
assigned to a task and status of task. The other
worksheet is a summary tab. I want to know how many
tasks Mike has marked complete. Something like- add all
instances where A:A (being the resource column) is Mike
and D
(being the status column) is complete.I know sumif and countif but I can't get them to work
with multiple conditions.
Please help!