Did you mean a count of those who said Y to BOTH (Y in A column and Y in B
column for same person)? If so the SUMPRODUCT answers are the correct ones.
Mine gave you the Y count for a single column
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