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