Problem: In
Excel I want to average the values in column C when the criteria and criteria
range in column A (see below screenshot).
Solution: You
can do this with an Array formula (for all Excel versions) of with Non Array
formula (only for Excel 2007 & higher).
The same Array formulas we can also be used to
calculate maximum and minimum values.
