flyfishing2542
New Member
- Joined
- Jan 27, 2009
- Messages
- 11
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.
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.