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

N

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 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
 
O

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
 
M

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.
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top