Counting responses

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

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???
 
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
 
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
 
Back
Top