Thread
:
I want to be able to input "Y" or "N" and tally them as 1 or 0.
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
lia
external usenet poster
Posts: 4
I want to be able to input "Y" or "N" and tally them as 1 or 0.
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 Quote
lia
View Public Profile
Find all posts by lia