Absolute value

  • Thread starter Thread starter Seeker
  • Start date Start date
S

Seeker

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.
 
Back
Top