Trump/Ukraine, What Will He Do?
News1 min ago
Excel-Wndows 7
I have 2 workbook pages. In one, when increasing the size of the table I am using, I have to adjust the TOTAL column manually to include the cells added in the new range, whereas in the second page, this is done automatically with no manual adjustment necessary. What do I need to do in the set up of the first page to achieve it operates automatically same as page 2. Thanks for any help.
Answers
1 to 4 of 4
Best Answer
No best answer has yet been selected by BJS. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
I suspect you have the table set up differently in each sheet.
It depends on where you are inserting new columns in relation to the range being summed..If the new columns are inside the summed range, then the total formula will adjust accordingly. If outside the range, it wil not be included.
eg data in cols A,B,C,D. Col E left blank
Col F = SUM(A1:E1)
now click on col E heading and insert column. Formula will include it.
Another possibility is that you may be using = A1 + B1+ C1 + D1
Such formulae will never automatically include any added columns.
It depends on where you are inserting new columns in relation to the range being summed..If the new columns are inside the summed range, then the total formula will adjust accordingly. If outside the range, it wil not be included.
eg data in cols A,B,C,D. Col E left blank
Col F = SUM(A1:E1)
now click on col E heading and insert column. Formula will include it.
Another possibility is that you may be using = A1 + B1+ C1 + D1
Such formulae will never automatically include any added columns.
I have obviously not worded my question correctly. What I was trying to say was say the table has 6 columns with 20 lines down. If I increased the table to say 30 lines down in 1 page the 6 totals in the total line would update to include the extra 20 lines whilst in the other book, I had to manualy readjust the total in the 6 columns Does that make it more clearer another MAGIC (SENIOR) moment.
In Office 2003, there is the facility on the Tools menu to select Options, then Calculation. I'm guessing that whatever version of Office you're using has something similar. One of your workbooks will have the Automatic tab ticked, the other one may not. If that's the case, tick it and away you go.
Good luck
Good luck
Again another MAGIC moment I should have said that my version is Excel 2010. I have checked and as far as I can see the Automatic function is enabled. I have opened a new Excel page and doing a 2 line sum, then increasing it by adding another cell but the sum does not include the figure in the new cell.
I have tried to compare the settings in the workpage that works OK against the one that does not but cannot see any obvious difference. I'm stumped.
I have tried to compare the settings in the workpage that works OK against the one that does not but cannot see any obvious difference. I'm stumped.
1 to 4 of 4
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.