How do I ignore N/A values in this SUM? (Google Sheets)-CodePudding

I don't know how to implement the IFNA function to my formula, could you please help? I'm using Google Sheets.

=SUM($G7 $I7 $K7 $M7 $U7 $W7 $AB7 $AE7)

Thank you

CodePudding user response：

Make an array with the values and apply IFNA to each one before calculating the sum:

=SUMPRODUCT(IFNA({$G7,$I7,$K7,$M7,$U7,$W7,$AB7,$AE7}))

Note that SUMPRODUCT() works like SUM(ArrayFormula()

CodePudding user response：

You don't need signs when using a formula like SUM or SUMIF

For example, the same as your SUM formula above would be =SUM($G7,$I7,$K7,$M7,$U7,$W7,$AB7,$AE7)

One way to handle your error would be to wrap each item in IFERROR formulas

=SUM(iferror($G7,0),iferror($I7,0),iferror($K7,0),etc...)

So for each one, it will show ZERO instead of an error.

SUMIF is more helpful if you are summing up an entire row or column, with specific filtering criteria