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