Need to update formula after inserting rows

**4lowie** · 05-04-2014, 02:49 AM

Hi everyone
I have some formula's that look at a range of rows

Please Login or Register  to view this content.

The trouble is I insert rows to add new data to my sheet, this then changes the formula. $A$9 then becomes $A$10, I don't want this. I want the start of the formula to stay the same. How do I do this?

Cheers Dave

**RudiS** · 05-04-2014, 03:10 AM

This should work...
=COUNTIF(INDIRECT("$A$" & 9 & ":$A$214"),H22)

**RudiS** · 05-04-2014, 03:17 AM

If you need the bottom to be relative, you could modify it to something like this...

=COUNTIF(INDIRECT("$A$" & 2 & ":$A$" & COUNT(A:A)),H22)

**4lowie** · 05-04-2014, 04:08 AM

Thanks for that. Just what I needed.

Need to update formula after inserting rows

LinkBack

Thread Tools

Rate This Thread

Display

Need to update formula after inserting rows

Re: Need to update formula after inserting rows

Re: Need to update formula after inserting rows

Re: Need to update formula after inserting rows

Thread Information

Users Browsing this Thread

Similar Threads

Update reference cell after inserting new rows

Inserting Rows, formula update

Inserting rows formulas dont update

update formula chain when inserting rows

[SOLVED] Automatically update links in Excel 2003 after inserting rows in .

Bookmarks

Bookmarks

Posting Permissions