| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Is it possible to count the number of "yes" answers?
I have a column of "yes" and "no" answers in a spreadsheet and I'd like to
create a formula that will count how many "yes" and "no" answers I have. Can Excel do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Is it possible to count the number of "yes" answers?
Gina, =COUNTIF(A:A,"yes") =COUNTIF(A:A,"no")
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Gina" wrote in message ... I have a column of "yes" and "no" answers in a spreadsheet and I'd like to create a formula that will count how many "yes" and "no" answers I have. Can Excel do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Is it possible to count the number of "yes" answers?
Thank you, Paul B! That worked!
"Paul B" wrote: Gina, =COUNTIF(A:A,"yes") =COUNTIF(A:A,"no") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Gina" wrote in message ... I have a column of "yes" and "no" answers in a spreadsheet and I'd like to create a formula that will count how many "yes" and "no" answers I have. Can Excel do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Is it possible to count the number of "yes" answers?
Your welcome
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Gina" wrote in message ... Thank you, Paul B! That worked! "Paul B" wrote: Gina, =COUNTIF(A:A,"yes") =COUNTIF(A:A,"no") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Gina" wrote in message ... I have a column of "yes" and "no" answers in a spreadsheet and I'd like to create a formula that will count how many "yes" and "no" answers I have. Can Excel do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Excel not taking number format consistently | Excel Discussion (Misc queries) | |||
| How do I count the number of cells in a column in excel that begi. | Excel Discussion (Misc queries) | |||
Linear Mode
