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")




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