Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

Maybe SUMIF/COUNTIF

Vaya con Dios,

Chuck, CABGx3


"TinaMo" wrote in message
...
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

Hey thanks...but what about the MEDIANIF? Do you know if MS Excel 2003 has
a MEDIANIF function?
"CLR" wrote:

Maybe SUMIF/COUNTIF

Vaya con Dios,

Chuck, CABGx3


"TinaMo" wrote in message
...
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

Tina,

Array enter (using Ctrl-Shift-Enter) a formula like:
=MEDIAN(IF($B$2:$B$200=E2,$C$2*:$C$200))
That will return the median of numbers in C2:C200 where B2:B200 matched cell
E2.

For AverageIf, use SumIF/CountIF.

HTH,
Bernie
MS Excel MVP


"TinaMo" wrote in message
...
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

Thanks,

I will try it.

"Bernie Deitrick" wrote:

Tina,

Array enter (using Ctrl-Shift-Enter) a formula like:
=MEDIAN(IF($B$2:$B$200=E2,$C$2Â*:$C$200))
That will return the median of numbers in C2:C200 where B2:B200 matched cell
E2.

For AverageIf, use SumIF/CountIF.

HTH,
Bernie
MS Excel MVP


"TinaMo" wrote in message
...
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

If you have any problems getting this to work.

The following page might be useful:
http://www.bettersolutions.com/excel...N622911811.htm

regards

TinaMo,

Have you tried using MegaStat? It's an Excel Add-on that allows you to do
all kinds of special statistical functions in Excel. Very worth the $.

Good Luck!
--
Teri Albert


"TinaMo" wrote:

Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?

=AVERAGE(IF(rng=some_condition,rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"tralbert" wrote in message
...
TinaMo,

Have you tried using MegaStat? It's an Excel Add-on that allows you to do
all kinds of special statistical functions in Excel. Very worth the $.

Good Luck!
--
Teri Albert


"TinaMo" wrote:

Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?