Here is a Doosy

[flyfishing2542]

My issue is simply I can not either find or write a code that will work. I believe by now I have made this so HUGE in my head that I can not see the answer…. Please Help.

I have a Sales spreadsheet that follows each individual sale by salesman. For example:

Date / Product1 /Product2 / Salesman / Cost / address etc.

Now the issue is. (deep breath) :: I need to find out what the percentage of Product1 and product2 are; per salesman(there are 3).

Only 3 options exist for Prod1 and Prod2 N / N or N / <>N or <>N /N

Product1 is worth 50% of product2 in the average.

I have tried every formula I can think of and if by some miracle I was using the correct formula, it did not work properly.

 

[flyfishing2542]

I would like everyone to know that my last 2 weeks of mind bending hell are now over thanks to yytsunamiyy.

I just wanted to conclude this for anyone who is reading this.
yytsunamyiyy solved the problem. and Thank you all who tried to help.

/cheer