Hi

I need some help with an Excel formula.

I have used the sumproduct formula to add up the respective company code amount.

Each company code has a percentage split and I'm not sure if the sumproduct formula can accomodate it.

Test File uploaded with expected results.

Thanks,

arv

I need some help with an Excel formula.

I have used the sumproduct formula to add up the respective company code amount.

Each company code has a percentage split and I'm not sure if the sumproduct formula can accomodate it.

Test File uploaded with expected results.

Thanks,

arv