Forum Discussion
=SOM wont work
When I try =SOM(A1:A10) I get this error #NAME? Can someone help me?
So it works for me. But without the excel file, I can only guess and I don't want to.
Try = SUMPRODUCT (H1: H55), it should work without a problem.
If not, please insert a file (without sensitive data).
formula in English = SUMPRODUCT (H1: H55)
formula in Netherlands =SOMPRODUCT(H1:H55)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.