Excel Function/Formula help...Variable inside a SumIf ?

[tj832006]

I need some help with this project for work. I need a formula to add u
the total of 2-3 sets of user-added data..one colum of the data varie
how much is going to be added.
Example: A1 = 3 So the equation needs to pick up sum o
B1:B3=___. or A2 = 5 so sum of B1:B5 = __


how do i put that into the correct excel syntax and formula?
Any help? Please email me (e-mail address removed) with any help
Thank you

 

[Norman Harker]

Hi tj832006!

Use:

=SUM(INDIRECT("B1:B"&A1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Trevor Shuttleworth]

=SUM($B$1:OFFSET($B$1,,,A1))

=SUM($B$1:OFFSET($B$1,,,A2))

Regards

Trevor