In a list populated by 'Yes' and 'No' answers only, is there a formula that
will calculate the total number each response? E.g. Total 'Yes' rseponses
equals.....

Hi!

Assume the list is in the range A1:A10

=COUNTIF(A1:A10,"Yes")

=COUNTIF(A1:A10,"No")

Biff

"sruth" wrote in message
...
In a list populated by 'Yes' and 'No' answers only, is there a formula
that
will calculate the total number each response? E.g. Total 'Yes' rseponses
equals.....

use the COUNTIF() function at the end of the list. For example, if your list
is in column A and goes from row 1 to row 10, then in A10 enter
=COUNTIF(A1:A10,"Yes")
to see how many Yes entries there are.

"sruth" wrote:

In a list populated by 'Yes' and 'No' answers only, is there a formula that
will calculate the total number each response? E.g. Total 'Yes' rseponses
equals.....

try the conditional sum in Tools.
If you don't have it installed, then click it in add-ins.
or write a formula this way: {=SUM(IF($F$7:$F$9="YES";1;0))}
If your cells F7:F9 contain the values.
You can copy the formula to the line under and change "Yes" to "No" and the
formula will calculate the other expression.
The way to get the {} brackets is to press the Ctrl+Shift+Enter while in the
editing mode in the formula cell. (Or go in the formula cell, press the F2
key and then Ctrl+Shift+Enter.
sruth pÃ*Å¡e:

In a list populated by 'Yes' and 'No' answers only, is there a formula that
will calculate the total number each response? E.g. Total 'Yes' rseponses
equals.....