ExcelBanter - How 2 sum the abs values of several cells w 1 func in XL.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How 2 sum the abs values of several cells w 1 func in XL. (https://www.excelbanter.com/excel-worksheet-functions/70727-how-2-sum-abs-values-several-cells-w-1-func-xl.html)

bob

How 2 sum the abs values of several cells w 1 func in XL.

I'm trying to sum the absolute values of a column without adding another
column. Can I do this with one function?

Ron Coderre

How 2 sum the abs values of several cells w 1 func in XL.

Try something like this:

For positive and negative values in A1:A10
A11: =SUMPRODUCT(ABS(A1:A10))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"bob" wrote:

I'm trying to sum the absolute values of a column without adding another
column. Can I do this with one function?

All times are GMT +1. The time now is 05:36 PM.