hi there, i wounder if you could help me with what you may seem is a simple formula. I am trying to create a formula for a cell that caluclates the total amounts in a certain columns that are named a certain value in another column. I know that may not be that clear so heres an example.

Column 1 (Business Area)
Risk & Resilience
Performance Consulting
Performance Consulting
Performance Consulting
Systems solutions

Column 2 (Gross Profit)
45,000
68,500
100,000
500,000
10,000,000

So the total amount for Risk & Resilience is 45,000 and the total for performance consulting is 668,500.

I just need a formulas for a cell to automatically calculate this. Any ideas?

Thanks for your time and efforts in advance.