How this function is read?

[Mike]

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

[Don Guillett]

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
[email protected]
"Mike" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>