Forum Discussion

Broadview_writer1977's avatar
Broadview_writer1977
Copper Contributor
Jun 11, 2023
Solved

Auto sum only adds certain cells

When I try to add a column or row, it outlines a part of that row and gives a result based on that or else it just gives me a zero. I suspect there's some  kind of programming already embedded into t...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 11, 2023

    Broadview_writer1977 Well, auto-sum doesn't work very well when the data range contains empty cells.

     

    Enter zeroes in empty cells and redo auto-sum and it will work. Alternatively, manually enter =SUM(B2:B5) in B6 and copy across. Then =SUM(B2:H2) in I2 and copy down.

  • Broadview_writer1977's avatar
    Broadview_writer1977
    Copper Contributor
    Jun 11, 2023

    Riny_van_Eekelen 

    Thanks. I've altered the content, since the original file contained personal info. I'm not familiar with OneDrive so have used my Google Drive instead. I hope that works for you.  Appreciate your help.   https://docs.google.com/spreadsheets/d/1ITA6YmWZaJ2RAGnQ_ApONuqmFAHDc0zG/edit?usp=sharing&ouid=107902231586616877697&rtpof=true&sd=true 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 11, 2023

      Broadview_writer1977 Well, auto-sum doesn't work very well when the data range contains empty cells.

       

      Enter zeroes in empty cells and redo auto-sum and it will work. Alternatively, manually enter =SUM(B2:B5) in B6 and copy across. Then =SUM(B2:H2) in I2 and copy down.

      • WGRussell's avatar
        WGRussell
        Copper Contributor
        Jul 01, 2024

        auto sum stopped working in some cell...=+++ doesn't work either...I have run "repair" twice...i have entered zeros in empty cells...I have tried fill right from cell that calculates correctly...those solutions didn't work...I have used number, accounting & $...I have manually input =SUM( : ) and that doesn't work