R
Razi Malik
I have a group of identical worksheets. I would like to
group the sum totals of all. Normal way is to keep adding
by click particular cell on each sheet but I guess there
is a better way as indicated in the help menu of excel.
But it does not work. see screen dump which is exactly the
way it is described by excel
=sum('sheet 1:'sheet 4'!c8)
Can someone tell me how to go about and what is wrong in
the formula that I have entered.
This is what excel help menu gives.
For example, to combine the data in cell B3 from
worksheets Sheet 2 through Sheet 7 inclusive, you could
type =SUM(Sheet2:Sheet7!B3). If the data to consolidate is
in different cells on different worksheets, enter a
formula such as this: =SUM(Sheet3!B4, Sheet4!A7, Sheet5!
C5). To enter a reference such as Sheet3!B4 in a formula
without typing, type the formula up to the point where you
need the reference, click the worksheet tab, and then
click the cell.
group the sum totals of all. Normal way is to keep adding
by click particular cell on each sheet but I guess there
is a better way as indicated in the help menu of excel.
But it does not work. see screen dump which is exactly the
way it is described by excel
=sum('sheet 1:'sheet 4'!c8)
Can someone tell me how to go about and what is wrong in
the formula that I have entered.
This is what excel help menu gives.
For example, to combine the data in cell B3 from
worksheets Sheet 2 through Sheet 7 inclusive, you could
type =SUM(Sheet2:Sheet7!B3). If the data to consolidate is
in different cells on different worksheets, enter a
formula such as this: =SUM(Sheet3!B4, Sheet4!A7, Sheet5!
C5). To enter a reference such as Sheet3!B4 in a formula
without typing, type the formula up to the point where you
need the reference, click the worksheet tab, and then
click the cell.