Formula to group multiple rows

[piggle]

Hi,

I am designing a report but have come accross an issue that I need help with.

I need a formula that will group multiple row amounts into one line, so that I can link this data to another spreadsheet. Below is an example of the data that I want to group:

COST CENTRE AMOUNT

• abc123 200
  abc123 100
  abc123 150
  abc123 60

What formula can I use that will enable me to give me the abc123 cost centre with a total of 510? I need the result on the next column so that I can use a VLOOKUP in the other spreadsheet. The result should look something like this.

It would even be better if the results were on a seperate sheet so I can utilise the VLOOKUP function on the results, with no blank rows.

• COST CENTRE AMOUNT CENTRE AMOUNT
  
  abc123 200
  abc123 100
  abc123 150
  abc123 60
  ABC123 510

It would be great if someone could help me.

Thanks,

Piggle.

 

[Aladin Akyurek]

Have a look at the SUMIF function.