| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with questionnaire responses | Excel Worksheet Functions | |||
| no responses... | Excel Discussion (Misc queries) | |||
| HELP!!! Counting Selective Responses if 2 conditions are met? | Excel Worksheet Functions | |||
| counting responses - please help | Excel Worksheet Functions | |||
| adding up yes, no, n/a responses | Excel Discussion (Misc queries) | |||
Linear Mode
