» Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
Columns A & B contain the number of points scored by a particular player during each quarter of a game.
An empty cell indicates that no points were scored during that quarter.
When using the following Array formula to total the points scored during the 2nd half, #VALUE! is returned.
Use the SUM, IF, and ISNUMBER functions as shown in the following Array Formula:
It is most likely that the blank cell in column A is actually not empty, but contains an invisible space.
Using the ISNUMBER and IF functions overcomes any errors.
To apply Array formula:
Select the cell, press and simultaneously press .
Use the SUMIF function as shown in the following formula:
|Screenshot // Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas|