Excel: Is it possible to count the number of "yes" answers?  
Author Message
GeoffD





PostPosted: Wed Oct 18 07:45:09 CDT 2006 Top

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?

Excel243  
 
 
Paul





PostPosted: Wed Oct 18 07:45:09 CDT 2006 Top

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



>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?


 
 
Gina





PostPosted: Wed Oct 18 08:13:02 CDT 2006 Top

worksheet functions >> Excel: Is it possible to count the number of "yes" answers? Thank you, Paul B! That worked!



> 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
>


> >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?
>
>
>
 
 
Paul





PostPosted: Wed Oct 18 08:19:58 CDT 2006 Top

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



> Thank you, Paul B! That worked!
>

>
>> 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
>>


>> >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?
>>
>>
>>