counting how many cells meet a given criteria

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

Similar Threads

Counting rows that meet multiple criteria 5
Assigning an overarching owner to a task 0
Counting # of cells with that meet criteria in two columns 7
how to get the median of cells that meet a given criteria in excel 1
counting how many times a certain month appears 3
Conditional Formatting Between Worksheets 0
How to sort data from one worksheet into other worksheets? 2
How many days the progress behind the plan? 3

Top