Excel summation formula with internal variable range.

[Arubal]

Is it possible in excel through standard functions or macros to sum a formula/equation that has a value inside that ranges from 1 to x.

Example: Cell A1 will have a formula ( (1+2)*X)/5 where x ranges from 1 to Cell B2

So if B2 = 3 then Cell A 1 should be [((1+2)*1)/5] + [(1+2)*2)/5] + [(1+2)*3)/5] = 3.6

Thanks.

 

[Fluff]

Hi & welcome to MrExcel.
One option would be

=SUM(((1+2)*ROW(INDIRECT("1:"&B2))/5))

 

[Norie]

If you have Excel 365 you could try this.

=SUM((1+2)*SEQUENCE(B2,1)/5)

 

[Fluff]

If you have Excel 365 you could try this.

The OP's profile shows 2010

 

[Marcelo Branco]

Maybe...

=SUMPRODUCT((1+2)*ROW($A$1:INDEX($A:$A,B2))/5)

M.