Adding 4 cells next to eachother and then adding the following fourcells

[nadia.younus]

Hi,

I have two worksheets: 1 and 2. In worksheet 1, I have all my raw
data. In worksheet 2, I want to only display the sum of some of the
cells in worksheet 1

e.g. Worksheet 1

A B C D E F G H
1 10 12 25 36 87 21 36 32
2 25 55 88 63 54 74 25 33

Worksheet 2

A B
1 (sum of cols A11) (sum of cols E1:H1)


Now, I can easily do a =SUM('Worksheet1'!A11) and place the total
value in cell A1 of worksheet 2. What I then need is something which
will sum up the next four values in Worksheet 1 i.e. Cells E1:H1 and
place that total in Wroksheet 2's cell B1.

Highlighting and dragging the formula in worksheet 2 sums up B1:E1,
when I actually need it to sum up E1:H1. Does anyone know how I can do
this? I'm happy to use macros if you are able to guide me in the right
direction

Thanks,

Nadia

 

[Otto Moehrbach]

Maybe I'm missing something, but just write the formula in B1 to sum E1:H1
of sheet1 and drag that formula down. HTH Otto

 

[Mike H.]

After you drag the formula just hit F2 and change the B to an E and the E to
an H.
Then just copy both the formula in Col A and the formula in Col B down and
you're all set.

 

[nadia.younus]

Hi Mike and Otto,

Thanks for your help. I was hoping there was an easier way than having
ot go into every cells and changing the cell reference but I guess
not

Nadia