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