COUNTIFS stopped working

[solotech]

Hi

My dropdowns have been working fine. Each time a selection is made, a text cell increments plus 1 etc.

The problem is PC wide, as no spreadsheet dropdown selection will increment.

A few changes were made to the Trust Centre in order to prevent Excel asking any silly questions.

Any ideas why COUNTIFS would just stop?

Excel Office 365

Thanks for any help.

 

[JazzSP8]

Have you checked that Calculation is set to Automatic?