Hi! I am working on a spreadsheet which will show the 10 items with the most
inventory at each account, measured by weeks on hand. Weeks on hand is
calculated by dividing the value of inventory on hand by the averages sales
for the past several weeks (usually 13).

This is fairly straightforward unless an item has had no sales, or negative
sales (due to seasonality). Obvioulsy the formula will return #DIV/0! or a
negative number. Can someone help me with a formula that will return a value
that will return a value that can be sorted in descending order for
distribution to my coworkers, and easy population into presentations?

Thanks for any help you can give.
--
Diane