SIMPLE FORMULA TO RETURN '1'Closed

Question

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 · Answer

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")

SIMPLE FORMULA TO RETURN '1'

1 response

Similar discussions

Subscribe To Our Newsletter!