look in the help index for COUNTIF or SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John Wright OCC" <John Wright wrote in
message ...
I have a column that has Y's and N's in it, I need to tally the number of
Y's
in the column. Is there a function or some other option for doing this?