How to automatically update a sumif formula when adding rows.

**gabealexander** · 06-02-2022, 04:42 PM

Is there a way to have the sumif formula automatically update when adding rows, without having to insert the row before the last row of data?

The current formula is sumif(L19:L29, D4, E19:E26). If I insert multiple lines after row 26, how can I update the formula to include those rows automatically and not have to manually update?

I have multiple novice users utilizing and updating the spreadsheet and am trying to make it as easy as possible to have the summary automatically update to limit the lift and also mistakes.

**FlameRetired** · 06-02-2022, 05:45 PM

Hello gabealexander. Welcome to the forum.

I am partial to using Dynamic Named Ranges. They resize automatically to fit data. They are referenced in formulas by their name.

Without an upload workbook (as requested in the 'gold' banner at the top of the page) I will have to guess that the data in column L is text.

Give each of these formulas a relevant name in Name Manager.

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

Then your formula could be =SUMIF(Names,D4,Amnts)

If any numbers in column E are larger than 25^25 use something larger.

How to automatically update a sumif formula when adding rows.

LinkBack

Thread Tools

Rate This Thread

Display

How to automatically update a sumif formula when adding rows.

Re: How to automatically update a sumif formula when adding rows.

Thread Information

Users Browsing this Thread

Similar Threads

update formula in a different sheet while adding rows

VBA code automatically update when adding rows.

[SOLVED] How to Have a Formula Automatically Update When Adding

How to update the range in a formula automatically when adding rows of data to a worksheet

Adding or deleting rows in master sheet and automatically update target sheet

[SOLVED] Adding Rows To Update A Formula

[SOLVED] Automatically adding new rows with formula

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions