This is a migrated thread and some comments may be shown as answers.

ABS function error

1 Answer 18 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
zou
Top achievements
Rank 1
zou asked on 10 Dec 2018, 05:58 AM

in the sheet ,

a cell with formula =SUM(ABS(E88:E116)) see  the function1.png

another cell with formula =SUM(E88:E116) see the function2.png

between E88 and E116 ,I only enter the E113 with value 34, the E114 with value -30

the problem is :

     the result of formula =SUM(ABS(E88:E116))  aways equal to E88, how to solve this? or am I using wrong fomula??

 

 

1 Answer, 1 is accepted

Sort by
0
Polya
Telerik team
answered on 12 Dec 2018, 03:24 PM
Hi Zou,

The =SUM(ABS(E88:E116)) formula is an array formula, which is currently not supported by RadSpreadsheet. We have a feature request logged for this in our Feedback Portal where you can vote for it and track its status: https://feedback.telerik.com/document-processing/1356134-spreadprocessing-support-for-array-formulas.

As I understand you wish to create a function that sums the absolute values of a range of cells.
If my assumption is correct, you achieve that by using the following formula: =SUMIF(E88:E116,">0")-SUMIF(E88:E116,"<0"). The first SUMIF sums all the values that are greater than zero, and the second sums all those less than zero. When you subtract the second sum from the first you get the sum of all the absolute values as a result.

Hope this helps and is suitable for your scenario.

Regards,
Polya
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
zou
Top achievements
Rank 1
Answers by
Polya
Telerik team
Share this question
or