If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?
|
#2
|
|||
|
|||
Maybe SUMIF/COUNTIF
Vaya con Dios, Chuck, CABGx3 "TinaMo" wrote in message ... Is there any way to get an AVERAGEIF & MEDIANIF function in Excel? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
Is there any way to get an AVERAGEIF & MEDIANIF function in
If you have any problems getting this to work.
The following page might be useful: http://www.bettersolutions.com/excel...N622911811.htm regards |
#7
|
|||
|
|||
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
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? |
#8
|
|||
|
|||
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
=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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"AverageIF" alternative | Flutie99 | General Discussion | 2 | May 27th, 2005 11:03 PM |
Create an AVERAGEIF function. | as | Worksheet Functions | 2 | March 2nd, 2005 01:27 PM |
AVERAGEIF ?? | Don Guillett | Worksheet Functions | 2 | February 4th, 2004 01:33 AM |