Absolute value

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
 
R

Rick Rothstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Rows with Conditions 0
Use index and match function to get data from pivot table 1
Pivot Table Calculated Fields 4
Summing a Column - Net and Absolute Values 4
Sum of a range of absolute numbers 4
Subtotal data excluding negitive numbers. 3
ABS in SUBTOTAL 3
Using sum function with absolute numbers 6

Top