Create an AVERAGEIF function.

A

as

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

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

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.
 
Top