I should have added: do not put the formula in column A
If it must be in column A: COUNTIF(A1:A200,"Y") but change the 1 and the
200 to agree with your first and last cell
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"DJ" wrote in message
...
Got sheet with 2 columns with Y and N responses in both; need to know how
many people said Y in answer to first question and Y to 2nd question - but
how???
--
DJ