I am trying to create a "blank" cell if certain conditions are met (divide by zero) so that the resultant value in the cell will trigger a "skip" when using the COUNTA function. As an example, I have a cell formula of =IF(ISBLANK(cell reference)," ",(fixed cell)/(cell reference)). If the cell reference is zero, the formula "should" return a blank.
Unfortunately, " " (double quotation mark-spacebar-double quotation mark) does not create a "blank" that the COUNTA function recognizes.
What is the correct way to create such a blank?