Deactivating and reactivating cells

D

digitalprince

how can I deactivate/reactivate a large number off cells as a scenario?

I am operating with a 5 year budget, and would like to be able to switch
between different horizon alternatives (1-5 years) by simply deactivating the
cells connecting to the remaining years ( for example, if I want to use a 2
year horizon, I need to deactivate the cells for year 3-5).

Anyone?
I would really appreciate some help here:)
 
D

Debra Dalgleish

YOu could use an offset formula. For example, with budget amounts in
columns B:F, enter a number between 1 and 5 in cell J1.

In cell G2, enter:
=SUM(OFFSET(B2,0,0,1,$J$1))
and copy down to the last row of data.
 
Top