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)
--
Gary''s Student - gsnu200777


"Mal" wrote:

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.
--
Mal