counting how many cells meet a given criteria



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: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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question