| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting 'Yes' or 'No'
has I have a list of information that answers either yes or no. I would like
to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting 'Yes' or 'No'
On Wed, 12 Nov 2008 02:40:09 -0800, slavenp
wrote: has I have a list of information that answers either yes or no. I would like to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! Check out the COUNTIF function in HELP. --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting 'Yes' or 'No'
Hi,,
=COUNTIF(A1:A1000,"yes") And of course change to NO for no. Mike "slavenp" wrote: has I have a list of information that answers either yes or no. I would like to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting 'Yes' or 'No'
It would be helpful to know what column those values of yes and no are
in - assume it is column F. You can use these formulae to count them: =COUNTIF(F:F,"Yes") =COUNTIF(F:F,"No") Don't put the formulae in column F. Hope this helps. Pete On Nov 12, 10:40*am, slavenp wrote: has I have a list of information that answers either yes or no. *I would like to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting 'Yes' or 'No'
Try this ="Yes - "&COUNTIF(Range,"Yes")&" No - "&COUNTIF(Range,"No")
-- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "slavenp" wrote: has I have a list of information that answers either yes or no. I would like to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting 'Yes' or 'No'
Thanks for the help guys!
"Ron Rosenfeld" wrote: On Wed, 12 Nov 2008 02:40:09 -0800, slavenp wrote: has I have a list of information that answers either yes or no. I would like to be able to count how many yes and no answer there are in the coloum. If you need extra info, let me know. I am using excel 2007. Thanks for the help! Check out the COUNTIF function in HELP. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting | Excel Discussion (Misc queries) | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| How to do: If 'yes', then show extra columns | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Linear Mode
