Formula to group multiple rows

piggle

New Member
Joined
Jun 11, 2002
Messages
4
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.
 

Forum statistics

Threads
1,077,783
Messages
5,336,304
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top