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")
Tips - Windows 10 20H2 KB5006670 installation Error 0x800f081f
During these weeks I tried to install KB5006670 patch but it was unsuccessful. Each time installation ended with 0x800f081f error code.
I solved problem manual downloading, and installing, below patch:
https://www.catalog.update.microsoft.com/Search.aspx?q=KB5006670