how to specify a range that is variable.

  • Thread starter Thread starter Mal
  • Start date Start date
M

Mal

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
 
You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain:

C
F
3
5

In A5 enter:

=SUM(INDIRECT(A1&A3&":"&A2&A4))
this is the same as entering:
=SUM(C3:F5)
 
Thanks Ryan....Named Ranges are under-utilized and should be given more
publicity.
 
Back
Top