Strip the sign from a number so it's always positive.
Copy this formula
=ABS(A2)ABS returns the magnitude of a number without its sign. It's useful for differences where direction doesn't matter, like the gap between forecast and actual.
=ABS(A2-B2)→30Absolute difference between two values.
Use SUMPRODUCT(ABS(range)) to total values ignoring their signs.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.