How to calculate the average of amounts below a certain amount

New Contributor

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 Replies
best response confirmed by Grahmfs13 (Microsoft)

@jbisset75 That could something like:


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

That's it! Thank you.