Create an AVERAGEIF function.
 

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

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


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

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.

"as" wrote:

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