|
|
Excel: Is it possible to count the number of "yes" answers? |
|
Author |
Message |
GeoffD
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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?
>>
>>
>>
|
|
|
|
|
|
|