AVERAGEIF

[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

 

[Frank Kabel]

Hi Kim
one way: the array formula
=AVERAGE(IF(range=condition,range))

 

[Guest]

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

 

[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)