Forum Discussion
Solved
Formula worked in Excel under windows10 but not in Windows 11
=SUMPRODUCT(((Urenregistratie!A2:A2500)=1)*(Urenregistratie!I2:I2500)) The Formula above worked in Excel under windows10 but not in Windows 11, did something change? How can I make my formula work ...
Is the interface language different between the two systems? In Dutch, for example, SUMPRODUCT should be SOMPRODUCT.
Please try to open attached file in your locale, it has nothing but
=SUMPRODUCT((Urenregistratie!A2:A2500=1)*Urenregistratie!I2:I2500)Above is for English version of Office in English locale. When opened, it shall be shown correct formula for your locale.