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