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!

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

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!

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!

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!

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