Need help with an IF statement

  • Thread starter Thread starter BeadLdy
  • Start date Start date
B

BeadLdy

I have a column of cells that contain one of two things, either 3
letters or nothing at all. These are used for evaluation purposes. If
the cell contains text, I want it to return a value of "1", if there is
nothing in the cell, I want it to return a value of "0".

Now, at the bottom of the column, I want to know how many cells had
text in them. How do I do that?
 
Hi

for the IF statement try
=IF(A1="",0,1)

For counting the non blanks try
=SUM(IF($A$1:$A$999="",0,1))
enter this as array formula (CTRL+SHIFT+ENTER)
or use
=COUNTA($A$1:$A$999)

HTH
Frank
 
Back
Top