Linking values from another sheet to another and adding them together and getting rid of duplicate values

[psmi123]

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function.

Functions	Revenue
1A	$24.00
2A	$54.00
3A	$36.00
5A	$23.00
8A	$25.00
9A	$42.00
11A	$35.00
13A	$75.00
1B	$79.00
2B	$6.00
3B	$80.00
5B	$7.00
6B	$46.00
8B	$45.00
1C	$26.00
2C	$84.00
3C	$58.00
4C	$25.00
6C	$13.00
8C	$25.00
1D	$47.00
2D	$39.00
3D	$59.00
3E	$23.00
4E	$15.00
5E	$62.00
6E	$72.00
7E	$54.00
8E	$11.00

<tbody>
</tbody>

I want to find the revenue of each sector, the sectors are made of solutions and the solutions are made of the functions. So i need to find out an approach on how to count the revenue per sector but i dont want it counting revenue for the same function more than once because there are solutions that share the same function and i dont want them being counted twice.

Sector	Sector Solution	Functions	Functions	Functions	Revenue
Auto	Sedan	1A	2A	3A
Auto	Crossover	1A	5A	2A
Auto	Bike	2A	8A	9A
Auto	Coupe	3A	11A	2A
Auto	Supercar	13A	2A	3A
Aero	Jets	1B	2B	3B
Aero	Boat Plane	2B	5B	6B
Aero	Small Planes	3B	8B	2B
Energy	Wind	1C	2C	3C
Energy	Water	4C	1C	6C
Energy	Solar	1C	8C	4C
Gas	Mining	1D	2D	3D
Technologies	Blockchain	5E	7E	3E
Technologies	IoT	4E	5E	6E
Technologies	5G	7E	8E	5E

<tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...getting-rid-duplicate-values.html#post5102787

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.