Awesome! It works. I see now what I was and wasn't doing. Thank you, Thank
you! I really appreciate your help on this. This will help me in other
reports as well.

"Glenn" wrote:

OK, first it looks like you missed the part about array formulas needing to be
committed by hitting CTRL+SHIFT+ENTER.

Also, this is a two-cell solution. The formula you entered could/should be in a
hidden cell, and then the second formula would be displayed. Try it this way
(copy directly from this post if possible):

R6 = SUM(($F$2MMULT(H5:Q5,(COLUMN(H5:Q5)=TRANSPOSE(CO LUMN(H5:Q5)))+0))+0)
*** This is the array formula ***

D6 = R6+(($F$2-SUM(H5:INDIRECT("R"&ROW()-1&"C"&R6+COLUMN()+3,FALSE)))/
(INDIRECT("R"&ROW()-1&"C"&R6+COLUMN()+4,FALSE)))

Copy to R7 and D7 for the "High Value" results.


JLewis wrote:
File link he http://www.savefile.com/files/2013754

Thank you very much for your help!!!

Jennifer

"Glenn" wrote:

OK, but I can't help without more information. Either post your worksheet on
www.savefile.com or describe your exact data and formulas here so I can recreate
it on my end.


JLewis wrote:
It looks like this is on the same level as what I want to do, but I can't get
the formula to work. It gives me an error message saying "A value used in the
formula is of the wrong data type". I don't understand as all of the data
used in the formula is of the "Number" type.

"Glenn" wrote:

JLewis wrote:
I have a spreadsheet with current inventory on hand and the sales for each
month from the last year. I want to figure how many months our inventory on
hand will last based on the last years sales. For instance, WidgetA has 100
on hand and Mar, Apr, May, Jun & Jul sales were 5,10,15,40,60, respectively.
I know that we have 4.5 months supply, but I have to manually figure this
calculation. I have more than 400 items. This takes a long time to figure, is
there any way to automate the figuring of the months supply?
Look at this:

http://tinyurl.com/bndrvj

If you are having trouble making it work, put your worksheet on www.savefile.com
and I will see if I can help.