Create an AVERAGEIF function.

[as]

Introduce an AVERAGEIF function in Excel. Can currently do it, but only
combining SUMIF and COUNTIF... clumsy.

 

[Bob Phillips]

=AVERAGE(IF(A1:A100=condition,A1:A100))

enter as an array formula, that is commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[bj]

If you want something like an average of column C when Column A is a name
Try
=Average(if(A1:A50="name",C1:C50,"") entered as Array (Control Shift Enter)
The Criteria can be almost anything you want it to be.
This also works for Standard deviations etc.