Forum Discussion
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 the file I'm using. I'm trying to figure out how to attach a sample, but can't find the attachment icon if there is one. And might I add that I have no idea what I'm doing.... 😉
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 Share the file via Onedrive or similar.
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.
