Summarising totals

[QS Guy]

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.440
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.480
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>

 

[njimack]

Use a pivot table

 

[QS Guy]

Wouldn't know how to unfortunately

 

[Kumar Chandra]

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]

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