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?