How to copy formula and it following a pattern?

Hello, I'm new to the forum and have a question about Excel. I have looked all over the web, but have failed in coming up with a solution. Below is my issue:

I'm working with one worksheet that has two sheets,named PAGE 1 and PAGE 2. PAGE 1> column B contains dollar amounts for Gross Revenue starting at cell B131 and ending on cell B147.

PAGE 2 has a row in which three of the cells from PAGE 1 are added, for example B131-133. On the same row, but the next column, the same formula is entered but with each cell incrementing by one. Below is the formulas to show you what I mean.

='PAGE 1'!$B133+'PAGE 1'!$B134+'PAGE 1'!$B135

='PAGE 1'!$B134+'PAGE 1'!$B135+'PAGE 1'!$B136

As you can see, on the same row, but next column, the formula for the sum is increased by one cell each time.

What I'm trying to do is be able to copy this formula over to the next column, but within the same row, and following this pattern.

I've read and tried the OFFSET function, but I cannot get it to work.

Any help will be appreciated it. Thank you.

There is no simple formula to do what you want.
You can try this:
On Page 2 1st cell: =sum(indirect("'Page 1'!$B"&132+column(A1)&":$B"&132+column(A1)+2))
then copy it into the cell to the right

see if that gives you the results you want.

If you don't want it in column A then use =Sum(Indirect("'Page 1'!B"&132

DonkeyOte,

Thank you for the formula. The first formula appears on cell CC8 and from Page 1 it's only adding three cells at a time. I copied and edited your formula to the below:

=SUM(INDEX('PAGE 1'!$B$133:$B$135,COLUMNS($CC8:CC8)):INDEX('PAGE 1'!$B$133:$B$135,COLUMNS($CC8:CC8)+2))

When I copy the formula over the next column in the same row, it changes to this:

=SUM(INDEX('PAGE 1'!$B$133:$B$135,COLUMNS($CC8:CD8)):INDEX('PAGE 1'!$B$133:$B$135,COLUMNS($CC8:CD8)+2))

Now, the first time I tried it, it worked like a charm, but I got an #HREF! on the cell CN8 and I could not figure it out why.

I started from scratch, but now it only works on the first cell and not on any other one.

I don't know

I now understand the formula completely, but just in case, could you break it down for me?

I changed the formula back to how you set it up first and it's working flawless.

Question, the current range for Page 1 is B131-B137, but a new row is added every month. How can the formula take into affect such change for every month that is added? Can the first formula simply be changed and all the others will reflect such change?

Column B has the last cell as being the average of the entire column, so I don't know if that would work.

Got it, I'll give that a try. Thank you.

Alright, gave it a try and it works flawless, you're a genius.

I am having a similar difficulty, but I don't fully understand the formula used to remedy this problem.

On Page2 B4:
I summing data from Page1 from B6:Y6
and in B5:
I am summing data from Page1 from B9:Y9

Your solution should work in my case, but I cannot figure out what the arguments truly mean to the formula.

Help is appreciated.

EDIT: I understand that this is an old thread, but I figured making my own thread wasn't necessary.