AVERAGEIF

K

Kim

I have a set of numbers that I want to average if it falls within a certain
range. Is there a way to find an equivalent of SUMIF with AVERAGE function.
To get to the average using SUMIF, I had to find out how many numbers falls
within the range and then use SUM with array formula
=SUM(IF(condition,range,0))/n (n being the number falling within the range).

Any help is greatly appreciated.
Kim
 
R

Raj

Hi Ki

I would suggest another way out. To find out an average if a certain criteria is fulfilled use this.
=SUMIF(criteria, range, sum_range)/COUNTIF(criteria, range

The above formula shall give you the desired result, provided the criteria mentioned in the sumif and countif is the same

Regards

----- Kim wrote: ----

I have a set of numbers that I want to average if it falls within a certai
range. Is there a way to find an equivalent of SUMIF with AVERAGE function
To get to the average using SUMIF, I had to find out how many numbers fall
within the range and then use SUM with array formul
=SUM(IF(condition,range,0))/n (n being the number falling within the range)

Any help is greatly appreciated
Ki
 
B

Bob Phillips

Kim,

Be warned, this is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top