Formula Question

ARIZONA3433

Board Regular
Joined
Dec 8, 2005
Messages
56
Hi,

I have several SUM formulas that reference the same consecutive rows but
different columns (Example "=SUM(L14:L100)" ).

I would like to change the cell references to all the formula at one time.

Is this possible?

Thanks
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

ARIZONA3433

Board Regular
Joined
Dec 8, 2005
Messages
56
Thanks for that suggestion.

I was hoping to have an imput from something similar to this:

Period Row Range 14 To 100

Where the number are in separate cells but they would modify the formulas
when changed.

Can this be done?

Thanks
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Say A1 contains the start row and A2 contains the end row. You can use a formula like this:

=SUM(INDEX(L1:L100,A1,1):INDEX(L1:L100,A2,1))

Make sure the cell with the formula is outside the indexed range, or you will get a circular reference. Also make sure that neither A1 nor A2 are greater than the number of indexed rows, or you will get a #REF! error.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,131
Messages
5,576,284
Members
412,711
Latest member
daves1
Top