How to get excel to recognize pattern

Hi,

I have been working on a complex spreadsheet and am wondering how to insert a pattern.

Let's say that A1 is the sum of 4 columns of data, BC7:BG7.
I know that B1 will SKIP TWO columns and then be the sum of the next four columns after that. (BJ7:BM7).
C1 will skip two more columns and be the sum of the next four columns (BP7:BS7).
And so on and so forth.

Is there a way to get excel to realize what I am trying to do without taking all of the sums manually? Thanks so much for your help!!!

The logic of the incriments in your post is flawed, it's not consistent.

You said sum of 4 columns BC7:BG7 (that's actually 5 columns)
Then the next one is BJ7:BM7 (that IS 4 columns)

So if you actually meant sum 4 columns and skip 2 then sum next 4, and they are
BC:BF
BI:BL
BO:BR
etc..

Try
=SUM(OFFSET($BC7:$BF7,0,(COLUMNS($A1:A1)-1)*6))

I'm sorry. I actually meant BC:BF, BI:BL, BO:BR, and so on. And it will always be four columns each time. Unfortunately, the code you provided seems to be summing BC:BF each time. It is a great starting point though, thanks!

Originally Posted by Angelfish13

I'm sorry. I actually meant BC:BF, BI:BL, BO:BR, and so on. And it will always be four columns each time. Unfortunately, the code you provided seems to be summing BC:BF each time. It is a great starting point though, thanks!

The formula itself won't show the $BC7:$BF7 change to $BI7:$BL7
But using offset, it actually sums the correct ranges as you described.

You are right! The code is working perfectly I think I copied I pasted the code wrong the first time. Thank you so much for your help!!!

You're welcome, thanks for the feedback.