Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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   Report Post  
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by Claus Busch View Post
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 :)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 countifs for date range puck1263 Excel Worksheet Functions 4 January 18th 13 08:58 PM
Countifs and date comparison KennyD Excel Discussion (Misc queries) 3 May 8th 10 07:32 PM
COUNTIFS with a date for criteria... LUSN Excel Worksheet Functions 1 March 3rd 10 09:33 PM
countifs criteria includes date range JayH Excel Worksheet Functions 4 February 3rd 10 02:19 AM
Selecting data in a specific date range using COUNTIFS function Joe R @ AA[_2_] Excel Worksheet Functions 1 May 8th 09 02:29 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"