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?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()