ExcelBanter - Countifs with if and date range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countifs with if and date range (https://www.excelbanter.com/excel-discussion-misc-queries/448886-countifs-if-date-range.html)

cvhar87

Countifs with if and cell range

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

Claus Busch

Countifs with if and date range

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

Quote:

Originally Posted by Claus Busch (Post 1612292)

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

All times are GMT +1. The time now is 10:22 PM.