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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kevin" wrote in message
...
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

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

--
Don Guillett
SalesAid Software

"Kevin" wrote in message
...
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