Mar 07 2022 08:42 AM
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?
Mar 07 2022 08:46 AM
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.
Mar 07 2022 09:05 AM
Mar 07 2022 08:46 AM
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.