Summing from cell A1 to An

[gordongekko1]

I have a set of data. I want to be able to take the average from data entries a to b, where a and b are changeable parameters.

So assume the entered parameters are a = 50 and b= 100 in cells M5 and M6

I want the SUM(A50:A100), intuitively I thought it would be SUM(A(M4):A(M5)), but that isn't working.

Thanks for your help.

 

[Aladin Akyurek]

Try...

=SUM(INDEX(A50:A100,M5):INDEX(A50:A100,M6))

 

[shg]

=sum(index(a:a, m5):index(a:a, m6))

 

[gordongekko1]

THANK YOU! Wow that was driving me crazy. Much appreciated.

 

[Jonmo1]

Another way

=SUM(OFFSET(A1,M4-1,0,M5-M4+1))