Hi,
I have two ways of working out profit depending on which company we send work to.
I would like to write a function that takes this into account and does the math either way. I'm thinking this may be a SUMPRODUCT but not entirely sure.
Example:
Column A=Company
Column B=Gross Fee...