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
0
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
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.