Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
Anyone know if there is averageif type of function similar to sumif? Thanks. -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
There isn't a specific single function but in general if you want the average of B1:B10 when A1:A10 is "xxx" then either =AVERAGE(IF(A1:A10="xxx",B1:B10)) confirmed with CTRL+SHIFT+ENTER or =SUMIF(A1:A10,"xxx",B1:B10)/MAX(1,COUNTIF(A1:A10,"xxx")) which just requires ENTER -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
thanks, I am not familiar with the CTRL+SHIFT+ENTER, what does this do? -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
Try SUMIF/COUNTIF
HTH -- AP "rudy" a écrit dans le message de ... Anyone know if there is averageif type of function similar to sumif? Thanks. -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
Also note that next version of excel will have an averageif function
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "Ardus Petus" wrote in message ... Try SUMIF/COUNTIF HTH -- AP "rudy" a écrit dans le message de ... Anyone know if there is averageif type of function similar to sumif? Thanks. -- rudy ------------------------------------------------------------------------ rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
averageif
rudy Wrote: thanks, I am not familiar with the CTRL+SHIFT+ENTER, what does this do? See Chip Pearson's website for an explanation http://www.cpearson.com/excel/array.htm -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=536854 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce | Excel Worksheet Functions | |||
how can i calc averageif | Excel Worksheet Functions | |||
"AverageIF" alternative | Excel Discussion (Misc queries) | |||
Create an AVERAGEIF function. | Excel Worksheet Functions | |||
AVERAGEIF Function out there? | Excel Discussion (Misc queries) |