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

S

sruth

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

Biff

Hi!

Assume the list is in the range A1:A10

=COUNTIF(A1:A10,"Yes")

=COUNTIF(A1:A10,"No")

Biff
 
J

JLatham

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

Peter from Novartis

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