Hi experts,
I have subtotal values on group and they are mixed of positive and negative
figures, I need to sum up those figures no matter weather they are positive
or negative €˜=sum(abs(subtotal)). I tried subtotals function and pivot table
but have no idea how to turn those values into absolute one. In pivot table,
calculated filed added and sum showing positive figures by using if (xx<0,
xx*-1,xx) but total sum and grand total still picking the negative figures.
Is it possible to solve this problem without adding additional formula in
next column ??
Regards

How about this array-entered** formula (change the range to suit your
needs)...

=SUM(ABS(A1:A100))

**Commit this formula using Ctrl+Shift+Enter, not just Enter by itself.

--
Rick (MVP - Excel)


"Seeker" wrote in message
...
Hi experts,
I have subtotal values on group and they are mixed of positive and
negative
figures, I need to sum up those figures no matter weather they are
positive
or negative €˜=sum(abs(subtotal)). I tried subtotals function and pivot
table
but have no idea how to turn those values into absolute one. In pivot
table,
calculated filed added and sum showing positive figures by using if (xx<0,
xx*-1,xx) but total sum and grand total still picking the negative
figures.
Is it possible to solve this problem without adding additional formula in
next column ??
Regards

or non-array entered
=SUMPRODUCT(ABS(A1:A100))

If this post helps click Yes
---------------
Jacob Skaria


"Seeker" wrote:

Hi experts,
I have subtotal values on group and they are mixed of positive and negative
figures, I need to sum up those figures no matter weather they are positive
or negative €˜=sum(abs(subtotal)). I tried subtotals function and pivot table
but have no idea how to turn those values into absolute one. In pivot table,
calculated filed added and sum showing positive figures by using if (xx<0,
xx*-1,xx) but total sum and grand total still picking the negative figures.
Is it possible to solve this problem without adding additional formula in
next column ??
Regards