# Combining totals into one page of a work book.

#### Wideboards

##### New Member
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.

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.

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

any help?

pl

Replies
1
Views
365
Replies
3
Views
253
Replies
0
Views
251
Replies
2
Views
359
Replies
2
Views
303

1,203,483
Messages
6,055,679
Members
444,807
Latest member
RustyExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back