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