Forum Discussion
Riny_van_Eekelen
Platinum Contributor
Richard707 When Autosum just shows =SUM() but not a result, I suspect that the numbers are texts. See picture below.
Did you copy/paste them from somewhere else? Or perhaps did you format the column/range as Text before you entered the numbers.
Richard_Leahy
Nov 09, 2023Copper Contributor
Hi Riny,
Thanks for that; so you're saying I should be sure all the numbers are formatted as numbers not "general?"
I did that but still no luck. When I highlighted the column and either use "Autosum" or type "=SUM and then (column letter number: column letter end number) I get "30+F1F3:F25" in the first cell, or "#NAME?" in the bottom cell. Where do I go from here?
Thanks,
Richard
Thanks for that; so you're saying I should be sure all the numbers are formatted as numbers not "general?"
I did that but still no luck. When I highlighted the column and either use "Autosum" or type "=SUM and then (column letter number: column letter end number) I get "30+F1F3:F25" in the first cell, or "#NAME?" in the bottom cell. Where do I go from here?
Thanks,
Richard
- Riny_van_EekelenNov 10, 2023Platinum Contributor
Richard_Leahy No, I didn't say that. The should be numbers, If you, for instance, copy and paste a text consisting of just numbers into Excel it still is a text. You need to use Text-to-columns to transform these texts to real numbers. Only then you can do calculations with them.
Can you upload the file or share a link (Onedrive or similar) giving access to it?