[cell address containing inventory number] / average([range containing use
numbers])

I think that's what you're going for, though the answer would be 2.67

Ryan

"Steve" wrote:

I need to calculate months of supply. Supplied data is on-hand inventory and
a use forecast. For example:

Inventory 30
Use: Mo1 Mo2 Mo3 Mo4 ...
10 15 10 10
Answer: 2.5

The forecast may "use" more inventory than currently on hand since it may be
replenshied, but that is not part of this analysis.
Thanks