Microsoft Excel - Excel Formula Help

Asked By Brian Sweeney
26-Mar-09 09:09 AM

I am trying to calculate Inventory Months Supply. 

I can calculate the months suppply as shown below in multiple cells, but I am looking for a formula to do in one cell..   

The correct result in this example is: 2.26048 

Thanks!

It is not clear. Could you please explain the following?  It is not clear. Could you please explain the following?

26-Mar-09 11:38 AM
What is that you have done in the manual calculation? I am not able to figure out how you arrived at figures like 9,343,432 and 7,547,714 .. Or 21,428,522 and 1, 1, 0.26048

Manual calc  Manual calc

26-Mar-09 11:45 AM

The maunal calc is as shown below.  Thanks!

Your Excel rormula cumulative condition checking  Your Excel rormula cumulative condition checking

26-Mar-09 12:20 PM

=SUM((SUBTOTAL(9, INDIRECT(ADDRESS( ROW(C2),COLUMN(C2) )&":"& ADDRESS( ROW(C2), ROW(INDIRECT(COLUMN(C2)&":"&COLUMN(L2))) )))<=B3)*1)+1

 

Where B3 is your stock, C2 to L2 is your data range.

http://www.eggheadcafe.com/forumpost.aspx?topicid=66&forumpostid=10085286  

Thanks. How are C6 and D6 arrived?  Thanks. How are C6 and D6 arrived?
26-Mar-09 12:23 PM
end of post
See Satish's reply above.  See Satish's reply above.
26-Mar-09 12:42 PM
end of post
Formula is only showing whole months.  Formula is only showing whole months.
26-Mar-09 01:09 PM

Formula is only showing whole months.  How do I add the partial month of .26 to the formula?  Thanks

Can anyone convert result in cell M5 to one formula?  Can anyone convert result in cell M5 to one formula?
26-Mar-09 03:03 PM

Rows 2 and three are my data.

Cell M5 is the ending calculation of cells C4:L5.

Can anyone create formula where the result of cell M5 is done in one cell?

Create New Account
help
excel: count uppercase letters in a cell Excel excel: how to count uppercase letters in a cell Excel Worksheet Discussions Windows XP (1) Microsoft Excel (1) SUBSTITUTE (1) SUMPRODUCT (1) FREQUENCY (1) INDIRECT (1) COLUMN (1) LOWER (1) One way, = SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1, {"A";"B C";"D";"E";"F"; Another one: = SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1, CHAR(ROW(INDIRECT("65:90"))), ""))) - - Biff Microsoft Excel MVP If we know that no text will be longer
Indirect Excel i am referencing a worksheet using the indirect function. excel is automatically adding the active worksheet name to the formula which returns #REF. how can i how can i stop it from automatically adding the sheet name? thanks, Excel Worksheet Discussions Microsoft Excel (1) Worksheet (1 INDIRECT (1) Workseet (1) Assume we cannot see your worksheet and formula you are attempting to
How do I STOP this;;;;; Excel Excel 2007 How do I stop Excel from asking me to save changes when only the cursor has been moved? Previous versions did not do this. It is quite annoying. J Excel Discussions Microsoft Excel (1) Excel 2007 (1) RANDBETWEEN (1 INDIRECT (1) OFFSET (1) INDEX (1) RAND (1) INFO (1) Does your file contain formulas that
alpha numeric data validation for excel Excel I want to use a non vb formula in data validation for an excel formula to make the user enter the first 2 characters of a field as UPPERCASE i.e. AB12345 - the format is always the same 2 letters 5 numbers. Any ideas? Excel Worksheet Discussions Microsoft Excel (1) SUBSTITUTE (1) SUMPRODUCT (1) ISNUMBER (1) INDIRECT (1) PRODUCT (1) COUNT (1) UPPER (1) With the validated cell being A2: = 3DPRODUCT(- -(CODE MID(A2, ROW(INDIRECT("1:2")), 1))> = 3D65))*PRODUCT(- -(CODE (MID(A2, ROW(INDIRECT("1:2")), 1))< = 3D90))*PRODUCT
Conflict with Valid Range Reference Error in Microsoft Excel 2007 Excel Hi, While converting the Macros enabled Microsoft Excel 2003 to Microsoft Excel 2007 format, I am getting the following Conflict with Valid Range Reference Error. After clicking on the Ok \ OK to All buttons the VBA code in the Excel is not working as it is expected to. The following is the Error message. invalid