Switch Function based on Different column Reference

Hi All,   Hope you're ll doing good.   Just wanted to check if i can modify the below formula to switch for the differenct columns in differnt tables.   Currently its suming only for the Accoun...