Assuming your data starts in Row 2 and the Cell C2 contains the date you
want to check (this allows you to make multiple queries by simply changing
its value), you could use this formula...

=SUMPRODUCT((A2:A1000=C2)*(B2:B1000="Y"))

Adjust the maxium range value (row 1000 here) to suit your data.

Rick


"Tina Hudson" wrote in message
...
I want to add the number of times "Y" appears in a column, based upon the
date in another column. Here is my layout:

Col A Col B
Class Date Graduated?
8/4/2005 Y
8/4/2005 Y
8/4/2005 N
11/2/2005 Y
11/2/2005 Y

I want to know for how many who attended each class date, the number who
graduated .

This is what I tried
=IF(A1:A5,"8/4/2005",IF(B1:B5,"Y",CountA(B1:B5)))

It apepars at first to work (I get no error message), but I don't get a
value in the cell - I get #Value! error message instead.

I also tried:
=IF(A1:A5,"8/4/2005",COUNTIF(B1:b5,"Y"))

Same #Value! error in cell

Any help would be most appreciated!
Thanks,
Tina Hudson