IT and Engineer web site
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")
