Apache OpenOffice (AOO) Bugzilla – Issue 11383
Special SUM function which gives empty as a result of only empty cells
Last modified: 2013-02-07 22:39:30 UTC
Issue 11144 concerning chancing the SUM function so it returns nothing when all cells where empty will not be fixed because of compatibility to Microsoft Excel. So instead I will propose a new special SUM function which will return nothing and not a zero when all the cells are empty. Suggestion is SUM_EMPTY() Which works as SUM except that it returns nothing if all cells are empty.
Hi Bettina, one4you
Why not use the COUNT() to kown if all cells are empty.
The COUNT() function doesn't gives the wanted result. If all the cells in the area are empty then the result should be empty. If at least one cell in the area has a value then the result should be the sum of all the cells in the area.
My humble suggestion would be that Calc has enough functions as it is. One way to achieve the desired result with existing functions would be: =IF(COUNTBLANK(range)=no_of_cells_in_range;"";SUM(range)) eg =IF(COUNTBLANK(A1:B2)=4;"";SUM(A1:B2)) Does that mean the issue can be closed? HTH
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".