Thread: I want to be able to input "Y" or "N" and tally them as 1 or 0.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default I want to be able to input "Y" or "N" and tally them as 1 or 0.
=COUNTIF(A:A,"Y")/SUM(COUNTIF(A:A,{"Y","N"}))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"lia" wrote in message
...
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