How to calculate the average of amounts below a certain amount

[jbisset75]

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?

[#2 · Accepted solution]

@jbisset75 That could something like:

=AVERAGEIF(range,"<500",range)

where "range" refers to the range that you want the average to be calculated on. 

[#3]

That's it! Thank you.