Summarising totals

QS Guy

New Member
Joined
Oct 19, 2017
Messages
5
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.

1ExternalBathroom2A2P CF Groundm4.308
2ExternalBathroom2A2P CF Groundm4.274
3ExternalDry2A2P CF Groundm4.494
4ExternalDry2A2P CF Groundm3.354
5ExternalDry2A2P CF Groundm2.440
6ExternalDry2A2P CF Groundm12.915
7ExternalDry2A2P CF Groundm3.353
8ExternalDry2A2P CF Groundm4.480
9ExternalDry2A2P CF Groundm4.016
10ExternalDry2A2P CF Groundm1.834
11ExternalDry2A2P CF Groundm1.881
12External*******2A2P CF Groundm7.346
13External*******2A2P CF Groundm7.315

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

Some videos you may like

Excel Facts

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

Kumar Chandra

New Member
Joined
Jun 15, 2018
Messages
13
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
Joined
Jun 17, 2005
Messages
7,764
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,120
Messages
5,526,933
Members
409,730
Latest member
mimipiz

This Week's Hot Topics

Top