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...
Most likely, your "numbers" are actually TEXT. Make sure that they are numbers.
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.
Riny_van_Eekelen Yes... like I said I have selected the cells and marked them as numbers... but that doesn't change anything. Grrr.
Understand! But if you format a text as a NUMBER it will still be a text and the SUM function will not work. Say you have " 10" in A1. This a is a text. Try entering the formula =VALUE(A1) to make the text that looks like a number into a real number. Otherwise, upload you workbook so that I can have a look at it.
- Yessss, thank you bro, it worked fantastically !!!
