Aug 12 2021 12:15 AM
When I try =SOM(A1:A10) I get this error #NAME? Can someone help me?
Aug 12 2021 12:32 AM
@MerijnRT Looks like you are using an English Excel version. Use SUM in stead.
Aug 12 2021 12:34 AM
Aug 12 2021 12:37 AM
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.
Aug 12 2021 01:23 AM
Aug 12 2021 04:42 AM
@Anna-Karin Petrusson But SUM will not result in a #NAME? error if the range contains text. It just returns zero or whatever the sum of the real numbers in the range would be, that is, as long as the range itself doesn't contain cells with errors.