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" <(E-Mail Removed)> wrote in message
news:44464A35-6A74-48F4-9E32-(E-Mail Removed)...
> 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
>