After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 166764 - SUMIF not completely XL compatible
SUMIF not completely XL compatible
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-02-09 09:36 UTC by Helmut Wollmersdorfer
Modified: 2005-02-10 13:06 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sumif testcases sumif-test.xls (44.00 KB, application/octet-stream)
2005-02-09 09:37 UTC, Helmut Wollmersdorfer 		Details

Description Helmut Wollmersdorfer 2005-02-09 09:36:06 UTC 
Version details: 1.4.2-2 Debian/Sarge
Distribution/Version: Debian/Sarge

SUMIF(Range,Criteria,Sum_Range)
gives wrong results
  IF Range has width=1
  AND Sum_Range has width > 1

See testcases in sheet SUMIF of attached sumif-test.xls

IMHO minor severity, because easy workaround possible.
Comment 1 Helmut Wollmersdorfer 2005-02-09 09:37:24 UTC 
Created attachment 37230 [details]
sumif testcases sumif-test.xls
Comment 2 Morten Welinder 2005-02-09 16:16:42 UTC 
Confirmed.  (Verified that current Gnumeric and Excel differ as stated in
C56:K57.)
Comment 3 Jody Goldberg 2005-02-10 13:06:10 UTC 
There were two bugs
- OFFSET was returning transposed ranges
- SUMIF was not handling target_range of different shape than src_range.

To improve XL compat
- we no longer count TRUE as 1
- we explicitly #VALUE! 3d references

All of these have been fixed and backported.
Patches will be in 1.4.3 and 1.5.1