Previous Topic Next Topic

SIMPLE FORMULA TO RETURN '1'

Closed
ADAMSKI555 - Oct 28, 2009 at 01:09 PM
venkat1926 Posts 1863 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..
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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")
0

Similar discussions

WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response