Issue 11383

Summary: Special SUM function which gives empty as a result of only empty cells
Product: Calc Reporter: ooo
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, oc, openoffice
Version: OOo 1.0.2   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
URL: http://www.openoffice.org/issues/show_bug.cgi?id=11144
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description ooo 2003-02-11 10:22:29 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.
Comment 1 oc 2003-03-05 12:36:03 UTC
Hi Bettina,
one4you
Comment 2 mariosv 2005-01-21 00:11:37 UTC
Why not use the COUNT() to kown if all cells are empty.
Comment 3 ooo 2005-02-09 00:37:56 UTC
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.
Comment 4 drking 2006-11-25 15:39:37 UTC
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
Comment 5 bettina.haberer 2010-05-21 14:49:24 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".