Bug 81026 - KSpread should hava a SUMIF()-function
Summary: KSpread should hava a SUMIF()-function
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 1.3.1
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Bram Schoenmakers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-05-06 12:31 UTC by Bram Schoenmakers
Modified: 2004-08-24 23:00 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Bram Schoenmakers 2004-05-06 12:31:06 UTC 
Version:           1.3.1 (using KDE KDE 3.2.1)
Installed from:    Compiled From Sources
Compiler:          gcc 3.2 
OS:          Linux

It would be nice if KOffice had a SUMIF()-function, so it sums all values which match an expression.
Comment 1 Bram Schoenmakers 2004-08-10 00:34:07 UTC 
I've got a global working SUMIF() now. Will publish it later. (I was told it's the best thing to fix your own wishes ;)
Comment 2 Bram Schoenmakers 2004-08-24 23:00:44 UTC 
CVS commit by bram: 

o New function for KSpread: SUMIF(). This closes my own wish #81026.
  Syntax: SUMIF( check range; criteria; sum range )
  The last parameter is optional. If not given, the values in the check range will be summed.

o COUNTIF() supports more operators than 'equal to'

CCMAIL: 81026-done@bugs.kde.org


  M +4 -3      CHANGES   1.337
  M +12 -179   kspread_functions_database.cc   1.15
  M +154 -0    kspread_functions_helper.cc   1.7
  M +39 -5     kspread_functions_helper.h   1.4
  M +89 -9     kspread_functions_math.cc   1.39
  M +27 -0     extensions/math.xml   1.32