Hi there
Can someone help me to build a formula to sum an exemple like this:
The column goes from "A10 to A20" and i have the cell "D10" to imput a value to say that it will allways start in A10 but to end the "SUM" in the number defined by me, like sometimes it can sum only fromA1 to A3 or A1 "to the number that i imput on the cell" "D10" and have the result for exemple in cell D15.
Example:
If cell D10 have the value 5 SUM from A10 to A15.
If the number from cell D10 changes to 7 and SUM changes from A10 to A17.
Thank you so much.
Armando
![]()
Bookmarks