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

bob · Feb 9, 2006

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

Domenic · Feb 9, 2006

Try...

=SUMPRODUCT(ABS(A1:A100))

Hope this helps!