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


Citrix - NetScaler Gateway secondary password field login page hide procedure

 If you are using Netscaler MFA authentication you might face below problem.


To hide second password 2 request you need to follow below Citrix article:

https://support.citrix.com/article/CTX215611

Tips - Notepad how to compare two files

 Notepad has an interesting feature that permit to compare, each character, about two files.

This simple article well explain step by step procedure.

http://www.technicaloverload.com/compare-two-files-using-notepad/

Outlook 2016 - Report Phish button not working

During these weeks we faced Outlook Report Phish but to work properly when submitting suspiciouses emails.


We are sorry we couln't access Report Phish. Make sure have a network connection. If the problem continues please try again later  (Dismiss this message).

Problem was due this Internet Explorer Setting:

  • In Internet Explorer, click Tools button --> click Internet Options. 
  • Click the Security tab, and then select the Internet Sites Zone
  • Select the Enable Protected Mode check box, and then click OK
  • Restart Internet Explorer and outlook


In case icon graphics is not as expected you should proceed, on IE, like below screenshot:


To fix completely problem you need to apply all steps here indicated.

https://docs.microsoft.com/it-it/outlook/troubleshoot/user-interface/default-office-addin-icon-displayed-outlook-ribbon