Forum Discussion
Impossible to sum numbers in Excel
I hope someone can help with this because I am pulling my hair out. When I try to sum numbers in a column, at the bottom of the page it gives me a count and not a sum. When I try to Autosum, it g...
Riny_van_Eekelen or anyone else I have the same problem, and I cant get it fixed, can I maybe give my excel sheet to you so you can check? I got the excel sheet from another program (YOCO) and have tried all the suggestions..
Regards
Lena
Lena1987 You can send it to me in a direct message or share it via OneDrive, Dropbox or something similar.
I am having similar issue. I tried every step you described in previous scenario, on my sheet, but still no luck. Can you help me with my sheet.
eagle1981 Similar or the same? This is an old thread and deals with a classic problem where users think that formatting a cell as a number doesn't change the content to a number if it is a text.
check the cells you are summing with ISNUMBER(cell_ref). Does it return TRUE? If not, you are dealing with texts that look like numbers.
- How do you fix this in modern excel? The text to columns "wizard" isn't a thing for me... It just has options to select "tab," "semicolon," "comma,", "space,", or "custom." I have this data coming into my excel workbook from an MS form, and although it's set as "number" on the form, and the column type in my workbook, when I do the ISNUMBER(cell ref) formula, I am getting "false." Can someone please help?
