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 A1:D1) (sum of cols E1:H1)


Now, I can easily do a =SUM('Worksheet1'!A1:D1) 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

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
wrote in message
...
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 A1:D1) (sum of cols E1:H1)


Now, I can easily do a =SUM('Worksheet1'!A1:D1) 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

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.

" wrote:

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 A1:D1) (sum of cols E1:H1)


Now, I can easily do a =SUM('Worksheet1'!A1:D1) 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

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