View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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.....