Create one quick & simple formula in Monday.com

I need a formula in monday.com that will add the total amounts from a specific column but only from the items that are marked as the same dependency. When the dependency names are the same then total the amount of all of the similarly named dependencies.

Here is a link to help explain what formula we need https://www.loom.com/share/1915ed935b8e41a08fb9a966109e392c