Formula to calculate allocation base on % of a Total amount

[joeltran]

Hi Everyone.

This is my output data at the moment. I just need help please with the formula on column J (Amount 7) on the below screenshot.

I need this amount 7 = Sub total amount 6 x Allocation % 

at the moment when I created the formula, I only have the value in the Total row only.

Thanks for your help,

Joel

[binu_acs · Accepted solution]

@joeltran one way of doing this

[joeltran]

Thank you so much @binu_acs  It works perfectly! Have a great weekend