Including values in range if it meets two criteria.

Hey peeps.

I might be stupid here, but I have been sitting with this problem for some hours and I cant really get it to work.
I have a big (10.000) range of data, of which I want to find a min. value, a max. value and calculate an average value.
However, there are some fluctuations in the data, which should not be included and therefore do I not want to include
values below 20 or above 35.

How do I set up a function to manage this instead of having to specify the different ranges manually?

Thank you in advance.

- Rasmus

Can you post a sample workbook?

Helper column:
in D2

Please Login or Register  to view this content.

Then Min:

Please Login or Register  to view this content.

Max:

Please Login or Register  to view this content.

Average:

Please Login or Register  to view this content.

To check, you can FILTER with BETWEEN then set the less than to 35 and greater than to 20. you can see the average when you select it all. and the min and max are at the top and bottom of the filter.

Yeah, helper columns can make other formulas MUCH more simple.

Yeah I had to triple check your question because it just seemed too easy to solve. Haha

Ha, yeah.
Usually solving people's questions is a fresh perspective and/or the ability to re-frame the problem and use excel's native functionality (like pivot tables which I almost recommended as well.)