can i calculate the number of occurances of a partucular value?
 

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

can i calculate the number of occurances of a partucular value?
 

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

can i calculate the number of occurances of a partucular value?
 

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

can i calculate the number of occurances of a partucular value?
 

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