Hi, I am trying to calculate the total cost of all my projects, however my projects are in multiple parts but the cost at the end of each part is still the same
| Project Name | Project Part | Budget |
| Project 1 | Part 1 | £123.45 |
| Project 1 | Part 2 | £123.45 |
| Project 1 | Part 3 | £123.45 |
| Project 2 | Part 1 | £45.95 |
| Project 2 | Part 2 | £45.95 |
| Project 3 | Part 1 | £68.72 |
| Project 3 | Part 2 | £68.72 |
| Project 3 | Part 3 | £68.72 |
| Project 3 | Part 4 | £68.72 |
| Project 3 | Part 5 | £68.72 |
Example table above, I want to calculate the total amount of the budget column however I only want to do it for each project and remove any duplicates so that the total amount I should get should be ££238.12
Unfortunately I cannot do this manually as the data gets update live on Sharepoint so I will need a formula for this! Thanks in advance for anyone that can help.
