Hello Nander,
To determine the sales ranking corrrectly would require including the
cost of each item. Without using a weighted average, you can't actually
determine which item(s) is/are responsible for 80% of the sales in
dollars. The only time quantity would be an accurate gauge is when you
are being paid piece rate.
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=514172