Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 Last edited by cvhar87 : June 14th 13 at 05:35 PM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
Thank you Claus. You've made it look so easy :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2010 countifs for date range | Excel Worksheet Functions | |||
Countifs and date comparison | Excel Discussion (Misc queries) | |||
COUNTIFS with a date for criteria... | Excel Worksheet Functions | |||
countifs criteria includes date range | Excel Worksheet Functions | |||
Selecting data in a specific date range using COUNTIFS function | Excel Worksheet Functions |