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.
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.
I know what each word means, but I am not at all clear on what the sentence means. A great example of what one writer (Lewis Thomas) once described as the maddening ambiguity of the English language.