Forum Discussion
Solved
Averaging based on a condition
Hello all, I am wanting to calculate a single average value based on a criterion in a range. I have a list of entities, the number of members associated with that entity, and a Y/N categorical fi...
For consistency, I always use the IFS version of the formulas. There is little to be gained from having two functions with slightly different syntax to do the same job.
= AVERAGEIFS(memberCount, ratingMet, "Y")[I also use defined names for all references]