dbcooper88
New Member
- Joined
- Dec 3, 2016
- Messages
- 36
Hello board. Let say you have a range of number like 1,5,6,8. How would I ignore a number thats below a certain value below the average of said range and return that average? TIA.
Once you have decided upon what range you will allow in your average, you can use the AVERAGEIFS function.Hello board. Let say you have a range of number like 1,5,6,8. How would I ignore a number thats below a certain value below the average of said range and return that average? TIA.
Let say you have a range of number like 1,5,6,8. How would I ignore a number thats below a certain value below the average of said range and return that average?
Once you have decided upon what range you will allow in your average, you can use the AVERAGEIFS function.
ADVERTISEMENT
Not sure I understand what you mean by "cell value", or how to average anything other than numbers. Can you clarify?AVERAGEIFS: For the criteria I want to put a cell value but it will only allow a numerical value. Any way around that?
Not sure I understand what you mean by "cell value", or how to average anything other than numbers. Can you clarify?
Put the number (not text) 77 in B1 and use criteria: ">"&B1.
- =AVERAGEIF (range, criteria, [average_range]). My criteria is >B1. However for it to work you have to put in a number for example >77. Am I missing something or is it even possible to put a reference cell value B1 for criteria?
Put the number (not text) 77 in B1 and use criteria: ">"&B1.