Thread: I want to be able to input "Y" or "N" and tally them as 1 or 0.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
  
Posts: 2,069
Default I want to be able to input "Y" or "N" and tally them as 1 or 0.
if your data is in cells a1:a30 try =COUNTIF(A1:A30,"y")/COUNTA(A1:A30)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"lia" wrote:

Out of 30 possible entries, I can have either y, n or blank. I want to
equate the sum of the "Y" and divide by the total number of y+n (not blank)
entries. Any ideas?
Reply With QuoteReply With Quote