Excel - Consolidation of several sheets in a workbook

  • Thread starter Thread starter Razi Malik
  • Start date Start date
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.
 
=SUM('Sheet 1:Sheet 3'!C8)

Use this Or

Put in two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last one.
this are empty sheets!!!

Te sheets in between will be sum
=SUM(start:end!C8)
 
Back
Top