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