I have the following simple offset formula:
=SUM(OFFSET(K14,0,0,1,-MIN($D14,COUNT($G14:K14))))/$D14
This formula works great for me as long as I do not add blank columns to my spreadsheet. Once I do, -MIN($D14,COUNT($G14:K14)) includes the blank cell in its count when determining the width to sum and messes up the formula.
Is there any way to adjust this formula such that if blank columns are added, the offset formula will not count the blank cell when determining the width to sum?
(Note: I am trying to calculate depreciation, where row 14 contains the CAPEX and D14 is the useful life.)
Bookmarks