Forum Discussion
Solved
How to calculate the average of amounts below a certain amount
Here's my issue. We have a number of gifts that were given to our organization (displayed in a column with one entry per row). I'd like to calculate the average of all those gifts below $500. What's the easiest way to do this?
jbisset75 That could something like:
=AVERAGEIF(range,"<500",range)where "range" refers to the range that you want the average to be calculated on.
2 Replies
jbisset75 That could something like:
=AVERAGEIF(range,"<500",range)where "range" refers to the range that you want the average to be calculated on.
- That's it! Thank you.
