If this is causing you a problem because you're trying to use COUNTA on the
results of the IF function adjust your COUNTA expression so that it becomes
=COUNTA(Range)-COUNTBLANK(Range) this will deduct the cells containing the "".

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Quinn Ramsey" wrote:

What is the character sequence that Excel uses to represent an empty cell? I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty. I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an empty cell.