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)
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...
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))