# SIMPLE FORMULA TO RETURN '1'

Closed
ADAMSKI555 - Oct 28, 2009 at 01:09 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 28, 2009 at 10:01 PM
Hello,

i want to create a very simple formula that will give me the answer '1' if the letter Y is entered in a column and '0' if the letter N is entered. I'm a complete maths idiot so can't work out how to do this..its for an invite list, so the layout is column 1, name; column 2, invited? (Y or N) column 3, confirmed? (Y or N) and i want the sheet to automatically add up the number of confirmed invitees..

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 28, 2009 at 10:01 PM
in wich column do you want 1 or 0 to come up
because your thrid column also is y or n.
why is this 1 or 0 necessary

suppose you want to know no of confirmed (which is in column 3 that is column C

suppose your database is like this

name invited(y/n) confirmed(y/n)
a y n
s n
d y y
f n
g y y
h n
some cells in column C are blank because there is nothing like confirmation if one is not invited.

in an empty cell(other than in column C type this formula

=COUNTIF(C:C,"y")