Forum Discussion
Solved
Calculate max sales volume in a given range of data from the last year daily data
Hi I have daily sales qty in the past year. I need to calculate a) what is the minimum sum of sales in the last year in any given day's range. For e.g. what is the minimum sum of sales in a 10 day...
I attached that I believe you can use as an example. You should be able to adjust the range references as needed.
Also, the formulas are array formulas and generally require you to hit Ctrl+Shift+Enter. But, the latest version of Excel may not require it, so if you hit Enter and get an error, go back into the formula bar and hit Ctrl+Shift+Enter.
Brilliant solution. Yes, it works. Thank you very much for your great help. Truly appreciate the quick response.
You're quite welcome.