Hi,

How are y'all doing? I'm working on a sheet that is driving me insane.

I want to make a sum up from one determed cell to a variable cell.
depending on the (variable)amount of weeks in a table, it needs to sum up that exact amount.

i got the amount of weeks in a cell, let call it A1. If A1 = 8 the second sumnumber needs to go 7 cells to the left.

in words:
Formula: copy to clipboard 
sum B1if A1=8 go seven cells to the right (H1))
in this case it should be =SUM(A1:H1)

who can help me with this issue?

Any input is appriciated!

Thanks