G

#### Guest

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.