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

"Danielle 76" wrote:


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 Last
Updated (Q) and Status (S).
On another sheet, I am sorting the data. There is a list of dates
entered in colum B. In coloum C, I want to show the count of a
"closed" status, if it occurs on a certain date (B).

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

Can anyone help?


--
Danielle 76
------------------------------------------------------------------------
Danielle 76's Profile: http://www.excelforum.com/member.php...o&userid=25895
View this thread: http://www.excelforum.com/showthread...hreadid=392775