Countif Multiple Cirteria

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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