Thread: Averaging Text vs. Numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Averaging Text vs. Numbers
a combination of the countif and counta functions would do it for you

=COUNTIF(A1:A4,"yes")/COUNTA(A1:A4)

Reply With QuoteReply With Quote