SOLVED

Excel: Making auto-sum adjust automatically to added lines

%3CLINGO-SUB%20id%3D%22lingo-sub-1348021%22%20slang%3D%22en-US%22%3EExcel%3A%20Making%20auto-sum%20adjust%20automatically%20to%20added%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1348021%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20created%20a%20spreadsheet%20in%20which%20the%20columns%20are%20totaled%20at%20the%20bottom%20using%20auto%20sum.%20I%20add%20lines%20for%20new%20entries%20at%20the%20top%20in%20order%20to%20s%3CSPAN%3Eee%20the%20most%20recent%20entries%20easily.%26nbsp%3B%3C%2FSPAN%3E%20However%20the%20auto%20sum%20does%20not%20adjust%20to%20include%20the%20newly%20added%20lines.%20Is%20there%20a%20way%20to%20make%20it%20do%20so%20automatically%3F%20Thanks%2C%20Ken%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1348021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20auto%20sum%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1348206%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Making%20auto-sum%20adjust%20automatically%20to%20added%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1348206%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637558%22%20target%3D%22_blank%22%3E%40Ken1122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20these%20columns%20are%20in%20a%20table%2C%20you%20can%20go%20to%20the%20Table%20Design%20tab%20and%20select%20the%20checkbox%20for%20Total%20Row.%20This%20should%20add%20a%20new%20row%20that%20sums%20up%20the%20column.%20When%20you%20add%20a%20new%20row%20to%20the%20table%2C%20it%20will%20adjust%20the%20range%20of%20the%20formula%20to%20include%20the%20newly%20added%20row.%20Here's%20a%20link%20to%20our%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2Fvideo-add-a-total-row-to-a-table-9885a56c-51b5-487a-a168-054afd034631%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Esupport%20page%3C%2FA%3E%20that%20goes%20over%20this%20feature.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446779%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Making%20auto-sum%20adjust%20automatically%20to%20added%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F478150%22%20target%3D%22_blank%22%3E%40Evan_Bolin%3C%2FA%3E%26nbsp%3BWhen%20I%20go%20to%20File%20menu%2C%20there%20is%20no%20Design%20tab.%20I%20do%20not%20find%20Design%20under%20any%20tab.%20Thanks%2C%20Ken%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448826%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Making%20auto-sum%20adjust%20automatically%20to%20added%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637558%22%20target%3D%22_blank%22%3E%40Ken1122%3C%2FA%3E%2C%20can%20you%20select%20your%20table%2C%20take%20a%20screenshot%20of%20what%20you%20see%20in%20Excel%20and%20share%20it%20with%20me%20so%20I%20can%20see%20exactly%20what%20you're%20seeing%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EEvan%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448834%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Making%20auto-sum%20adjust%20automatically%20to%20added%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448834%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F478150%22%20target%3D%22_blank%22%3E%40Evan_Bolin%3C%2FA%3E%26nbsp%3BHello%2C%20I'd%20rather%20not%20do%20that%20as%20it%20contains%20personal%20info.%20I%20changed%20the%20range%20from%20starting%20with%20the%20top%20line%20with%20data%20to%20the%20blank%20line%20above%20it.%20I%20haven't%20added%20more%20data%20yet%20but%20we'll%20see%20if%20that%20works.%20Thanks%2C%20Ken%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, I have created a spreadsheet in which the columns are totaled at the bottom using auto sum. I add lines for new entries at the top in order to see the most recent entries easily.  However the auto sum does not adjust to include the newly added lines. Is there a way to make it do so automatically? Thanks, Ken 

4 Replies
best response confirmed by Ken1122 (Occasional Contributor)
Solution

Hello @Ken1122 

 

If these columns are in a table, you can go to the Table Design tab and select the checkbox for Total Row. This should add a new row that sums up the column. When you add a new row to the table, it will adjust the range of the formula to include the newly added row. Here's a link to our support page that goes over this feature. 

@Evan_Bolin When I go to File menu, there is no Design tab. I do not find Design under any tab. Thanks, Ken

@Ken1122, can you select your table, take a screenshot of what you see in Excel and share it with me so I can see exactly what you're seeing?

 

Thanks,

Evan 

@Evan_Bolin Hello, I'd rather not do that as it contains personal info. I changed the range from starting with the top line with data to the blank line above it. I haven't added more data yet but we'll see if that works. Thanks, Ken