Is it possible to return the absolute value of a table column ranges?
Example: Returns a value (positive less negative values)
=SUM(tblBudget[[January]:[December]])
=SUM(ABS(tblBudget[[January]:[December]])) 'does not work and returns #Value
ABS Formula On A Table
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
ABS Formula On A Table
Regards,
John
John
-
- Administrator
- Posts: 78412
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ABS Formula On A Table
Confirm the formula with Ctrl+Shift+Enter to turn it into an array formula.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California