G
Guest
I have been using the COUNTIF function to count the occurences of dates that
fall between a particular set of dates.
Is there a way to count these dates, only if a cell on the same row as the
counted date equals 'Y"
This is the formula that I have been using to count occurences between
Dec.31-06 and Dec.31-07.
=COUNTIF(A1:A5,"<=12/31/07")-COUNTIF(A1:A5,"<=12/31/06")
Can I add to this in order to count the cells that also contain a "y" on the
same row?
Column A are the dates, Column B are the Y or N values.
A B
1 Sept-08-06 Y
2 Oct-24-05 N
3 Jul-21-07 N
4 Aug-10-07 Y
5 Jan-01-05 Y
The date COUNTIF formula shown above would result in 2. (A3 and A4)
The result I am looking for (with the "y") should be 1. (A4 only)
Any ideas ?
Thx.
fall between a particular set of dates.
Is there a way to count these dates, only if a cell on the same row as the
counted date equals 'Y"
This is the formula that I have been using to count occurences between
Dec.31-06 and Dec.31-07.
=COUNTIF(A1:A5,"<=12/31/07")-COUNTIF(A1:A5,"<=12/31/06")
Can I add to this in order to count the cells that also contain a "y" on the
same row?
Column A are the dates, Column B are the Y or N values.
A B
1 Sept-08-06 Y
2 Oct-24-05 N
3 Jul-21-07 N
4 Aug-10-07 Y
5 Jan-01-05 Y
The date COUNTIF formula shown above would result in 2. (A3 and A4)
The result I am looking for (with the "y") should be 1. (A4 only)
Any ideas ?
Thx.