# Summarising totals

#### QS Guy

##### New Member
Hopefully a straight forward answer to this one...

How do I get the totals for items that are the same in each column totalled.
Need 1-2 (4.308+4.274), 3-11, 12-13 etc.

I know it's easy to do it based on the sample below, but I've got tons of pages of data like this.

 1 External Bathroom 2A2P CF Ground m 4.308 2 External Bathroom 2A2P CF Ground m 4.274 3 External Dry 2A2P CF Ground m 4.494 4 External Dry 2A2P CF Ground m 3.354 5 External Dry 2A2P CF Ground m 2.44 6 External Dry 2A2P CF Ground m 12.915 7 External Dry 2A2P CF Ground m 3.353 8 External Dry 2A2P CF Ground m 4.48 9 External Dry 2A2P CF Ground m 4.016 10 External Dry 2A2P CF Ground m 1.834 11 External Dry 2A2P CF Ground m 1.881 12 External ******* 2A2P CF Ground m 7.346 13 External ******* 2A2P CF Ground m 7.315

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### njimack

##### Well-known Member
Use a pivot table

#### QS Guy

##### New Member
Wouldn't know how to unfortunately

#### Kumar Chandra

##### New Member
I think, Simply use =SUMIF(\$C\$2:\$C\$28,C2,\$E\$2:\$E\$28)

1. items= Column C,
2. C2 - Item Name.
3. Sum area= Column E.

It that what you looking for

#### njimack

##### Well-known Member
Wouldn't know how to unfortunately

1. I don't know what column headings you've used, so I'll assume "Type" for column B and "Amount for column E
2. Select any of the cells with data in
3. Go to the Insert menu, click on the first icon and select OK
4. A panel should appear to the right of the screen - tick the boxes next to "Type" and "Amount". Excel should recognise that Amount consists of numerical values, so it will be placed in the values area of the pivot table

Replies
4
Views
394
Replies
9
Views
554
Replies
3
Views
225
Replies
8
Views
779
Replies
0
Views
197