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 again?
Hope anyone can help me...
Best regards,
Rick.
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.
Is the interface language different between the two systems? In Dutch, for example, SUMPRODUCT should be SOMPRODUCT.
So I followed your advice, Both Windows and Office now have the default language "Dutch".
I still get an error... whet am I doing wrong?
=SOMPRODUCT((('Urenregistratie!'A2:A2500)=1)*('Urenregistratie'!I2:I2500))Urenregistratie is a TAB within Excel inside the same file as I am working.
Data in column A is numerical
Data in column I is also numerical with 2 decimals
> 'Urenregistratie!'A2:A2500
The second ' is in the wrong place - it should be before the !
But you don't need the single quotes since Urenregistratie does not contain spaces or punctuation.
Also see the reply by SergeiBaklan
Thanks, That might be the issue, I will see if that solves my issue.
