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

  • Thread starter Thread starter tj832006
  • Start date Start date
T

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
 
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.
 
=SUM($B$1:OFFSET($B$1,,,A1))

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

Regards

Trevor
 
Back
Top