which column are you wanting to transfer from transfers, D or E?

have you tried using a Vlookup SUM or a IFSUM formula might work for you.

Sorry i cannot provide the exact formula for you.