Hi
I'd use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve Kay" schrieb im
Newsbeitrag ...
HI Everyone, Can you help.
Column A has several countries listed. Column B has Y
(for Yes) or N (for No). There are over 4000 lines.
How can I count the number of "Y" under one country? I
would like to be able to see the totals of "Y" for each
country.