Please help me figure out how to make this summation work

Hi all,

Please refer to this image to understand my problem:
Screen Shot 2017-03-07 at 3.51.33 PM.png

I am trying to sum monthly values (Rows 18-21) into quarterly values (Rows 11-14). Then summing quarterly values into annual values (Rows 4-7)

The issue is that I can't use =SUM(H17:J17) and spread that out through row 10 starting at H10 because the values overlap each other.

When you expand =SUM(H17:J17) to the next cell it becomes =SUM(I17:K17) instead of =SUM(K17:M17) which is what I need.

Please let me know how to fix this, if possible.

Thanks!!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try

=SUM(OFFSET($H17:$J17,0,(COLUMNS($A:A)-1)*3))

Thanks! that worked. Now im just trying to understand how that function works.

You're welcome.

The key is the Columns Function

Put this in a cell by itself and drag it to the right, observe the results.

=COLUMNS($A:A)

Once you see what that does, it's simple math after that.