Excel Formulas

[Guest]

I would like to create a sumation formula that will pull in different values depending upon what I need.
For example, I want to add values in column A, however sometimes I want to go through row 10 and the next time through row 20.
So I want to create a formula that will give the value depending on the the row number I type in. For example if I type in 15 then I will get a sum of variables in column A of rows 1 through 15. If I type in 20 then I will get a sum of variables in rows 1 through 20.

How do I create such a formula? Any help would be much appreciated.

 

[Don Guillett]

You can just type it in your formula
OR
put 10 in another cell and use the INDIRECT function. Look in HELP index

--
Don Guillett
SalesAid Software
(e-mail address removed)

I would like to create a sumation formula that will pull in different

values depending upon what I need.

For example, I want to add values in column A, however sometimes I want to

go through row 10 and the next time through row 20.

So I want to create a formula that will give the value depending on the

the row number I type in. For example if I type in 15 then I will get a sum
of variables in column A of rows 1 through 15. If I type in 20 then I will
get a sum of variables in rows 1 through 20.