Hi,
I'm having trouble putting together a sumif formula. I am not entirely sure if sumif is the right choice here either so any help would be greatly appreciated.
So, i need to keep track of commission for three people. The commission will always split between all three salesman except whoever initiated would earn 2/3 of it and the remaining amount would be split between the other two salesman. I would like to see if its possible to find a formula that can do this for me.
Below i tried to break it down as much as possible. Right portion is only there to show the commission breakdown.
Again, any help would be greatly appreciated.
Thanks
I'm having trouble putting together a sumif formula. I am not entirely sure if sumif is the right choice here either so any help would be greatly appreciated.
So, i need to keep track of commission for three people. The commission will always split between all three salesman except whoever initiated would earn 2/3 of it and the remaining amount would be split between the other two salesman. I would like to see if its possible to find a formula that can do this for me.
Below i tried to break it down as much as possible. Right portion is only there to show the commission breakdown.
Again, any help would be greatly appreciated.
Thanks
Last edited: