Counting criteria dependant on dates

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

crashdown

Thread Starter
Joined
Oct 22, 2012
Messages
65
i need to Count how many cells in col(O) display a "Y" between dates in col(C)

at the moment i use countif but this just counts all the "Y"'s

Excel 2007

each row displays many columns of data

the counting takes place on another sheet in the book as the data sheet cant be edited

each job entry is not necessarily in the correct date order as they are listed per job number col(A)

so i would like a formula to look at each date, access whether it falls between the given dates, and report back how many entries within the dates is marked with a "Y"
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Hi, since I have absolutely no idea of what you have my suggestion may not work but maybe you could add an extra column that, based on a formula that checks a specifi dat that could be entered in let's zay Z1 puts a 1 in all cells in a column next to column C where the date should be counted for and then count all "Y' where that column = 1 ?

No version of Excel, no idea of the further lay-out, so it's just a blind suggestion... hope you can do something with it.
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
Another suggestion

The Y & N are in Column O
the dates are in Column C

so we need to know the dates you want to use between - in this forumla ,i'm using Cells H10 and I10 to show the dates between

and use this formula K10

Code:
=COUNTIFS(O:O,"Y",C:C,">="&H10,C:C,"<="&I10)
see attached
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top