Yeah, when I see a posted formula like:

=COUNTIF(A1:A5,"<=12/31/07")-COUNTIF(A1:A5,"<=12/31/06")

I always assume (for better or worse!!!) they meant = and <=. You know what
they say about assuming!


--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
I think that 12/31/06 should be excluded given the countif formula the OP
posted, that means it can be done using YEAR


--


Regards,


Peo Sjoblom


"T. Valko" wrote in message
...
Try this:

=SUMPRODUCT(--(A1:A5=DATE(2006,12,31)),--(A1:A5<=DATE(2007,12,31)),--(B1:B5="Y"))

Better to use cells to hold the criteria.

D1 = start date
E1 = end date
F1 = Y

=SUMPRODUCT(--(A1:A5=D1),--(A1:A5<=E1),--(B1:B5=F1))

--
Biff
Microsoft Excel MVP


"JLV" wrote in message
...
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.