ABS Formula On A Table

jstevens
GoldLounger
Posts: 2628
Joined: 26 Jan 2010, 16:31
Location: Southern California

ABS Formula On A Table

Post by jstevens »

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
Regards,
John

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: ABS Formula On A Table

Post by HansV »

Confirm the formula with Ctrl+Shift+Enter to turn it into an array formula.
Best wishes,
Hans

jstevens
GoldLounger
Posts: 2628
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: ABS Formula On A Table

Post by jstevens »

Thanks Hans!
Regards,
John