Hi everyone,

I have this Excel function:

=AVERAGE(IF(D$7:D$31=D14,E$7:E$31,""))

What does it mean? Or, how it can be read?

Thanks,
Mike

This is an array formula so it must be entered/edited with ctrl+shift+enter
it will average numbers in E for only those items in D that match d14

--
Don Guillett
SalesAid Software

"Mike" wrote in message
ups.com...
Hi everyone,

I have this Excel function:

=AVERAGE(IF(D$7:D$31=D14,E$7:E$31,""))

What does it mean? Or, how it can be read?

Thanks,
Mike

It says

Take the average of the cells in E7:E31 only where the equivalent cell
within D7:D31 is equal to the cell D14.

In simple terms, it allows conditional AVERAGE, MAX MIN etc, equivalent to
(the non-existent) AVERAGEIF

--

HTH

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


"Mike" wrote in message
ups.com...
Hi everyone,

I have this Excel function:

=AVERAGE(IF(D$7:D$31=D14,E$7:E$31,""))

What does it mean? Or, how it can be read?

Thanks,
Mike