formula hurdle

[jayalaxmi]

is there any formula to
Find difference in sale per customer between the highest selling & lowest selling sales persons?

 

[Pierre]

Hello,

Do you need the difference between max net sales and min net sales? (in that case: =MAX(C3:C15)-MIN(C3:C15))

Or the difference between max net sales per customer and min net sales per cusomer? (in that case: =MAX(C3:C15/B3:B15)-MIN(C3:C15/B3:B15) entered as an array formula with ctrl+shift+enter)

 

[PaulF]

I added a data set to break down sales per customer then used Min/Max Match/Index to pull your highest and lowest sales person for net sales per customer and give you the difference. See if this works for you...

Respectfully,
PaulF

 

[jayalaxmi]

Thanks paul

 

[Syedali]

Hi Paul,

Am having some doubts. Kindly clarify.

Highest Net Sale Per Customer: (Net sales,profit loss ) Juno.
but highest profit ratio is not juno it may be Josh.

I don't know exactly what the concept your doing i am trying to learn from you.

Thanks Paul

 

[jayalaxmi]

3. What is the netsales for the person who had 6 customers?

 

[Khalid NGO]

Hi Jaya,
There are 2 person who are having 6 customers:
If you want to sum all those try the following normally entered:
=SUMPRODUCT((B3:B15=6)*(C3:C15))
=SUMIF(B3:B15,6,C3:C15)

and this one with CSE:
=SUM(IF(B3:B15=6,C3:C15,0))

Regards,

 

[Syedali]

3. What is the netsales for the person who had 6 customers? 726
=+VLOOKUP(6,Table2[[No. Customers]:[Net Sales]],2,0)