I'm trying to sum the absolute values of a column without adding another
column. Can I do this with one function?
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 <[email protected]>,
bob <[email protected]> wrote:
> I'm trying to sum the absolute values of a column without adding another
> column. Can I do this with one function?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks