EXCEL - CONDITIONAL SUM = SUM.If (A1: A7, "<> # N / A")

Excel has a conditional function formula that execute sum based on some criteria.

Here it is command that sums all cells values except the one that has N/A value"

= SOMMA.SE (A1: A7, "<> # N / A")

= SUM.IF (A1: A7, "<> # N / A")