If

K

Kevin

If in rows 5 through 16 I have either entered nothing or an X, Using the if
command how would I in row 17 add every cell that I have entered nothing?

Kevin
 
B

Bernard Liengme

Hi Kevin:
This may not answer your question because it does not use IF but
I would use =COUNTIF(A5:A16,"")

If I was feeling paranoid I might be concerned than spaces and blanks look
alike but my formula would count only blanks, so I might use
=12-COUNTIF(A5:A16,"X")

If this was a homework assignment and I really MUST use an IF, then I would
show off and use
=SUM(IF(A5:A16="",1,0)) noting that it must be 'array entered' with
SHIFT+CTRL+ENTER not just plain ENTER
 
D

Don Guillett

how can you ADD nothing? Do you mean count? If so, look at the COUNTIF
function.
 
Top