ExcelBanter - average absolute values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - average absolute values (https://www.excelbanter.com/excel-discussion-misc-queries/92963-average-absolute-values.html)

Debbie

average absolute values

How can I average absolute values of cells with one firmula?

Ron Coderre

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?

All times are GMT +1. The time now is 07:46 AM.