C
count and sum function
I am a distribution analyst for a cat food company. I need to know how to
calculate the weeks of inventory I have on hand based on projected weekly
forecasts. For example, if I have 45 units on hand and a respective forecast
of 10 units per weeks, then I have a total of 4.5 weeks inventory
respectively. Needless to say this example is primative and my calculations
will not be as cut and dry, nor do I have to time to manually make the
calculation every day. So, I need to develop a formula that allows me to
count the number of cells in a certain range that when added respectively
will equal the value of a certain cell. Please help!
calculate the weeks of inventory I have on hand based on projected weekly
forecasts. For example, if I have 45 units on hand and a respective forecast
of 10 units per weeks, then I have a total of 4.5 weeks inventory
respectively. Needless to say this example is primative and my calculations
will not be as cut and dry, nor do I have to time to manually make the
calculation every day. So, I need to develop a formula that allows me to
count the number of cells in a certain range that when added respectively
will equal the value of a certain cell. Please help!