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.

[TABLE="width: 128"]
<tbody>[TR]
[TD]Functions[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD="align: right"]$24.00[/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD="align: right"]$54.00[/TD]
[/TR]
[TR]
[TD]3A[/TD]
[TD="align: right"]$36.00[/TD]
[/TR]
[TR]
[TD]5A[/TD]
[TD="align: right"]$23.00[/TD]
[/TR]
[TR]
[TD]8A[/TD]
[TD="align: right"]$25.00[/TD]
[/TR]
[TR]
[TD]9A[/TD]
[TD="align: right"]$42.00[/TD]
[/TR]
[TR]
[TD]11A[/TD]
[TD="align: right"]$35.00[/TD]
[/TR]
[TR]
[TD]13A[/TD]
[TD="align: right"]$75.00[/TD]
[/TR]
[TR]
[TD]1B[/TD]
[TD="align: right"]$79.00[/TD]
[/TR]
[TR]
[TD]2B[/TD]
[TD="align: right"]$6.00[/TD]
[/TR]
[TR]
[TD]3B[/TD]
[TD="align: right"]$80.00[/TD]
[/TR]
[TR]
[TD]5B[/TD]
[TD="align: right"]$7.00[/TD]
[/TR]
[TR]
[TD]6B[/TD]
[TD="align: right"]$46.00[/TD]
[/TR]
[TR]
[TD]8B[/TD]
[TD="align: right"]$45.00[/TD]
[/TR]
[TR]
[TD]1C[/TD]
[TD="align: right"]$26.00[/TD]
[/TR]
[TR]
[TD]2C[/TD]
[TD="align: right"]$84.00[/TD]
[/TR]
[TR]
[TD]3C[/TD]
[TD="align: right"]$58.00[/TD]
[/TR]
[TR]
[TD]4C[/TD]
[TD="align: right"]$25.00[/TD]
[/TR]
[TR]
[TD]6C[/TD]
[TD="align: right"]$13.00[/TD]
[/TR]
[TR]
[TD]8C[/TD]
[TD="align: right"]$25.00[/TD]
[/TR]
[TR]
[TD]1D[/TD]
[TD="align: right"]$47.00[/TD]
[/TR]
[TR]
[TD]2D[/TD]
[TD="align: right"]$39.00[/TD]
[/TR]
[TR]
[TD]3D[/TD]
[TD="align: right"]$59.00[/TD]
[/TR]
[TR]
[TD]3E[/TD]
[TD="align: right"]$23.00[/TD]
[/TR]
[TR]
[TD]4E[/TD]
[TD="align: right"]$15.00[/TD]
[/TR]
[TR]
[TD]5E[/TD]
[TD="align: right"]$62.00[/TD]
[/TR]
[TR]
[TD]6E[/TD]
[TD="align: right"]$72.00[/TD]
[/TR]
[TR]
[TD]7E[/TD]
[TD="align: right"]$54.00[/TD]
[/TR]
[TR]
[TD]8E[/TD]
[TD="align: right"]$11.00[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 534"]
<tbody>[TR]
[TD]Sector[/TD]
[TD]Sector Solution[/TD]
[TD]Functions[/TD]
[TD]Functions[/TD]
[TD]Functions[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]Auto[/TD]
[TD]Sedan[/TD]
[TD]1A[/TD]
[TD]2A[/TD]
[TD]3A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Auto[/TD]
[TD]Crossover[/TD]
[TD]1A[/TD]
[TD]5A[/TD]
[TD]2A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Auto[/TD]
[TD]Bike[/TD]
[TD]2A[/TD]
[TD]8A[/TD]
[TD]9A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Auto[/TD]
[TD]Coupe[/TD]
[TD]3A[/TD]
[TD]11A[/TD]
[TD]2A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Auto[/TD]
[TD]Supercar[/TD]
[TD]13A[/TD]
[TD]2A[/TD]
[TD]3A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aero[/TD]
[TD]Jets[/TD]
[TD]1B[/TD]
[TD]2B[/TD]
[TD]3B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aero[/TD]
[TD]Boat Plane[/TD]
[TD]2B[/TD]
[TD]5B[/TD]
[TD]6B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aero[/TD]
[TD]Small Planes[/TD]
[TD]3B[/TD]
[TD]8B[/TD]
[TD]2B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Energy[/TD]
[TD]Wind[/TD]
[TD]1C[/TD]
[TD]2C[/TD]
[TD]3C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Energy[/TD]
[TD]Water[/TD]
[TD]4C[/TD]
[TD]1C[/TD]
[TD]6C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Energy[/TD]
[TD]Solar[/TD]
[TD]1C[/TD]
[TD]8C[/TD]
[TD]4C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gas[/TD]
[TD]Mining[/TD]
[TD]1D[/TD]
[TD]2D[/TD]
[TD]3D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Technologies[/TD]
[TD]Blockchain[/TD]
[TD]5E[/TD]
[TD]7E[/TD]
[TD]3E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Technologies[/TD]
[TD]IoT[/TD]
[TD]4E[/TD]
[TD]5E[/TD]
[TD]6E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Technologies[/TD]
[TD]5G[/TD]
[TD]7E[/TD]
[TD]8E[/TD]
[TD]5E[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.