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

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
<(E-Mail Removed)> wrote in message
news:6d227518-8074-44d0-8056-(E-Mail Removed)...
> 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

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.

"(E-Mail Removed)" 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 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
>

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