Forum Discussion

philip369's avatar
philip369
Copper Contributor
Dec 05, 2019

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...
Excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor

philip369 

Most likely, your "numbers" are actually TEXT. Make sure that they are numbers.

Lena1987's avatar
Lena1987
Copper Contributor
Apr 01, 2022

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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 01, 2022

    Lena1987 You can send it to me in a direct message or share it via OneDrive, Dropbox or something similar.

     

    • eagle1981's avatar
      eagle1981
      Copper Contributor
      Nov 21, 2022

      Riny_van_Eekelen 

      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's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Nov 21, 2022

        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.

Resources