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