Forum Discussion
Can I create a formula to look at a date range, set criteria and return an average?
I have a spread sheet that contains rows with a fair bit of info. I'm looking to create a formula that will look for rows with a date within a certain range, then count the number of days between two...
I hope this helps. I've cut to just the data that is required. Basically I want to know how many days between the start and finish and then work out the average of all those that were positive within set date ranges.
Thank you again.
A workbook would have been better.
And I suspect you don't know the expected outcome. Which makes every solution a correct solution.
For the number of days.
=[@Finish]-[@Start]
Then create a pivot table.
| Outcome | Average of # of days |
| Negative | 148,75 |
| Neutral | -4,333333 |
| Positive | 179 |