Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |