Forum Discussion
Auto sum only adds certain cells
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.
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
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.
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
- I don't understand your question
- Thank you so much! Yesterday was a day of despair, experimenting with many different programs, hoping one would provide an solution for my project. Now I have hope.... and hopefully that will be my last dumb question -- but can't guarantee it. Cheers and have a great day.
Broadview_writer1977 A question is never dumb!! Even when it is easily answered. Though it may be 'dumb' not to ask the question if you really are stuck. Keep asking. It's the only way to learn.
