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...
jbisset75 That could something like:
=AVERAGEIF(range,"<500",range)where "range" refers to the range that you want the average to be calculated on.
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.