Countif Multiple Cirteria

  • Thread starter Thread starter Danielle 76
  • Start date Start date
D

Danielle 76

HELP!

I am trying to count the number of instances given a certain date.

On one worksheet, I have all my data. The coloums I am using are Las
Updated (Q) and Status (S).
On another sheet, I am sorting the data. There is a list of date
entered in colum B. In coloum C, I want to show the count of
"closed" status, if it occurs on a certain date (B).

I have tried the Sum Product, but it's not working. I have also trie
nesting an IF into a COUNT.. no luck - with and without array. I ge
values, but they are wrong, or the total count of the date range or o
the data!

Can anyone help
 
One way, assuming data in Q2:R37 on sheet3 then in C2 on sheet2

=SUM((Sheet3!$Q$2:$Q$37=Sheet2!B2)*(Sheet3!$R$2:$R$37="closed"))

entered as an array formula using Ctrl+Alt+Enter

Hope this helps
Rowan
 
Back
Top