close
I'm trying to sum the absolute values of a column without adding another
column. Can I do this with one function?
Try...
=SUMPRODUCT(ABS(A1:A100))
Hope this helps!
In article gt;,
bob gt; wrote:
gt; I'm trying to sum the absolute values of a column without adding another
gt; column. Can I do this with one function?
全站熱搜