Forum Discussion
=SOM wont work
When I try =SOM(A1:A10) I get this error #NAME? Can someone help me?
5 Replies
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.
- Are you trying to make a summarization of values in cells in Excel? In English Excel the function name is SUM not SOM.
- Also check that the cell contains numbers and not text. Check all cells, look for extra spaces.
Check the dataype is set to "Numbers" or "General" in the cells, not "Text".
You can also use the function =ISNUMBER(cell) to check the content of the cells.AnnaKarin 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.
MerijnRT Looks like you are using an English Excel version. Use SUM in stead.
