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/70728-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?

Domenic

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

Try...

=SUMPRODUCT(ABS(A1:A100))

Hope this helps!

In article ,
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:45 PM.