I have the formula.Please Login or Register to view this content.
When I insert a row, Excel naturally changes the formula to read.Please Login or Register to view this content.
I have read that I need to use 'OFFSET' so that the formula doesn't change because of the insert row.
Unfortunately, I am having trouble understanding how to apply it.
Would somebody please be so kind as to show me how to adjust the formula to do what I want, whether it requires 'OFFSET' or some other method.
Bookmarks