Excel Manipulating Allocation

Hello Friends,

i have a challenging task on excel, in which the cells with same color are subtracted to give the “Balance” colomn

the Excel will be more clear.

Allocation.xlsx (12.8 KB)

image