# run rate

1. ### AVERAGEIFS formula adjustment to replace a number within the range

Currently I am using a formula to calculate the last 7 days average to then use that average to project data as a run rate for the remaining days of the month. My current method is hindered due to if there is a slowdown in business (ie. Holiday, shutdown, etc.) the run rate will skew heavily...
2. ### Need a more automated formula for estimating a 2 month run rate

Hello, Hopefully someone can help me here. I'm in the process of automating a report that gets written and I'm down to one final formula that I need help with. Currently I use this formula to calculate a 2 month run rate =(((N14/1)*5)+O14)/2 The '5' represents the number of weeks left in a...
3. ### Run rate Weighted Formula

Help! I am having trouble making a weighted formula for a run rate.. If Number of days Passed (B4)<=15 each day should be weighted at .053 (1st 15days total .8) and if >15 then each days should be weighted at .364( last weeks totals .2) My run rate formula is MTD/number of days passed* number...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back