| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the equivalent of a "averageif" formula...
Hi: maybe something like this: =((SUMIF(F10:G13,F17,G10:G13))/COUNTIF(F10:F13,F17)) where range f10:g13 is list of sports f17 is sport to be averaged adjust ranges as needed hth plettieri -- plettieri ------------------------------------------------------------------------ plettieri's Profile: http://www.excelforum.com/member.php...o&userid=34531 View this thread: http://www.excelforum.com/showthread...hreadid=544914 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need the equivalent of a "averageif" formula...
Only downside to that is that blanks will count as zeroes. You could use an array formula: =average(if(a1:a5="whatever",b1:b5)) enter with control+shift+enter -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=544914 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
