Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Countifs with if and date range

5 views
Skip to first unread message

cvhar87

unread,
Jun 14, 2013, 12:16:40 PM6/14/13
to

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

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 are
different.

Thanks in advance




--
cvhar87

Claus Busch

unread,
Jun 14, 2013, 12:53:54 PM6/14/13
to
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")

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

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

cvhar87

unread,
Jun 17, 2013, 4:22:43 PM6/17/13
to

Claus Busch;1612292 Wrote:
> 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")-
>
> try:
> =COUNTIFS(A4:A232,"Q1",D4:D232,"Ack")
>
> Regards
> Claus Busch
> --
> Win XP PRof SP2 / Vista Ultimate SP2
> Office 2003 SP2 /2007 Ultimate SP2


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




--
cvhar87
0 new messages