SIMPLE FORMULA TO RETURN '1'

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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..

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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")
0