Combining totals into one page of a work book.

[Wideboards]

I have 18 sheets in a workbook. Each sheet is similar, each being the analysis of the areas of rooms in a single house and the costs of the hardwood flooring required for each area.

On another 'Totals' page, I want to have all the areas and quantities added up so that I can see the totals of each type of room - so for the all Breakfast room I want to add up all the cells in the 18 sheets which contain the area, the total cost, the adhesive cost, the oak cost, the labour cost etc.

I have tried everything I can think of but keep getting 'Circular error' messages. I have an Excel 'How to' book of 1300 pages but find it incomprehensible. I cannot find any useful reference to the problem.

 

[IML]

If you alway want to sum the same cell on your other worksheets, you could use something like
=SUM(Sheet2:Sheet18!B13)

on sheet 1 to sum the value of cell B13 on the rest of your sheets.

 

[plettieri]

A simple formular like =SUM(Sheet1:Sheet3!A17) should do to add cell A17 in sheets 1 thru 3.....


any help?

pl