SOLVED

Sum formula for cell value

Copper Contributor

Hello Everyone,

 

I needed a formula for monthly expense calculation. I couldnt find the way. Lets say if A1 is 3 then the sum formula should sum first 3 cells. If A1 is 4 then sum formula should sum first 4 cells. Etc. So i need a way to increase the end range of a sum table.

 

Thank you for your help

16526956001012118881252180553633.jpg

 

3 Replies
best response confirmed by Barbarosoruc (Copper Contributor)
Solution

Hi @Barbarosoruc 

 

_Screenshot.png

 

in B6:

=SUM(OFFSET(B4,,,,A1))

thank you so much! I did it@L z. 

Glad you have a solution & Thanks for providing feedback
1 best response

Accepted Solutions
best response confirmed by Barbarosoruc (Copper Contributor)
Solution

Hi @Barbarosoruc 

 

_Screenshot.png

 

in B6:

=SUM(OFFSET(B4,,,,A1))

View solution in original post