Adding to a column reference

[asnell3]

Hi there!

I am hoping this is possible in excel, although I'm not sure. In my formula, I am referencing a full column in another sheet (ex: Sample!B:B) to sum everything in column B. Is there a way to adjust that formula automatically so that in each row going down, it changes by one?

Example:
Row 1 sum(Sample!B:B)
Row 2 sum(Sample!B:B + 1) = sum(Sample!C:C)
Row 3 sum(Sample!B:B + 2) = sum(Sample!D:D)
...

Is this possible? Thank you!

[ChemistB]

Try

= SUM(OFFSET(B:B,0,ROWS($A$1:$A1)-1))

[asnell3]

Thank you so much!! Such a simple solution but saved me so much time!