| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average absolute values
How can I average absolute values of cells with one firmula?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average absolute values
Try this ARRAY FORMULA*:
For values in A1:A10 If there will be no blanks... B1: =AVERAGE(ABS(A1:A10)) OR If there may be blanks... B1: =AVERAGE(IF(ISNUMBER(A1:A10),ABS(A1:A10))) *Note: For array formulas, hold down [Ctrl] and [Shift] when you press [Enter], instead of just pressing [Enter]. Does that help? *********** Regards, Ron XL2002, WinXP "Debbie" wrote: How can I average absolute values of cells with one firmula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| copying an entire worksheet - need absolute values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
| How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
Hybrid Mode
