Counting responses
 

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

Counting responses
 

Let's say the first column is A
=COUNTIF(A:A,"Y")
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

Counting responses
 

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

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

Counting responses
 

=SUMPRODUCT((A1:A18="Question 1")*(B1:B18="Yes"))

Mike

"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???
--
DJ

Counting responses
 

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