Forum Discussion
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...
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
