Issue 11383 - Special SUM function which gives empty as a result of only empty cells
Summary: Special SUM function which gives empty as a result of only empty cells
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.openoffice.org/issues/show...
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-11 10:22 UTC by ooo
Modified: 2013-02-07 22:39 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".