Countifs with if and date range

C

cvhar87

I am trying to count the occurrences of "ack" in column D only if colum
A is Q1 and column D has "ack".


=IF(AND(A4:A232="Q1",D4 : D232="ACK"),COUNTIFS(D4 : D232,"ACK"),"N/A")

Right now it is returning just the result of logical true which is 57
but D4 to D32 has only 30 occurrences of ACK, the remaining ar
different.

Thanks in advanc
 
C

Claus Busch

Hi,

Am Fri, 14 Jun 2013 17:16:40 +0100 schrieb cvhar87:
I am trying to count the occurrences of "ack" in column D only if column
A is Q1 and column D has "ack".

=IF(AND(A4:A232="Q1",D4 : D232="ACK"),COUNTIFS(D4 : D232,"ACK"),"N/A")
Click to expand...

try:
=COUNTIFS(A4:A232,"Q1",D4:D232,"Ack")

Regards
Claus Busch
 
C

cvhar87

Claus said:
Hi,

Am Fri, 14 Jun 2013 17:16:40 +0100 schrieb cvhar87:
-
D232,"ACK"),"N/A")-

try:
=COUNTIFS(A4:A232,"Q1",D4:D232,"Ack")

Regards
Claus Busch
Click to expand...


Thank you Claus. You've made it look so easy :
 
Top