Thread: Counting responses
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Counting responses
=SUMPRODUCT(--(A1:A100="Y"),--(B1:B100="Y"))
--
David Biddulph


DJ wrote:
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???



Reply With QuoteReply With Quote