Forum Discussion
Trouble with adding numbers in a column
Hello, Just recently I've run into trouble adding the numbers in a column. I used to highlight the column and (thought) I went to the sigma/formula symbol and clicked on that. Even when it says "...
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.
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
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?