Forum Discussion
Formula worked in Excel under windows10 but not in Windows 11
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
I also noticed that 😉
Besides this, I changed the lanhuage from Windows and Office to Dutch.
Still it didnt work....
So I walked down in column A from row 2 until row 2500 and discovered that row 1339 had a value removed. This caused my problem.
Thanks for the quick replies and thinking along with me, your insights and knowledge are very valuable.
Have a great day!
Best regards,
Rick.