formula with in cell reference

L

Lamb Chop

A1 =5 B1=3
A2 =65
A3=12
....
....


How can I do this:


I want C1 have formula to do this:

the sum of A1 to A3

but if B1 change to 5 then

C1 = sum(A1:A5)

and when B1 change to 100
C1=sum(a1:A100)


ie. change the reference formula according to B1.

I have tried C1=sum(a1:A(B1))

but it does not work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top