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 171509 - SUMIF returns #VALUE! when range a sheet
SUMIF returns #VALUE! when range a sheet
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-03-24 18:06 UTC by kaliber
Modified: 2005-04-04 05:11 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
test case for sumif (1.66 KB, application/x-gnumeric)
2005-03-24 18:07 UTC, kaliber 		Details

Description kaliber 2005-03-24 18:06:00 UTC 
Version details: 1.4.3

Bad value in function sumif on multiple sheetstyles. In 1.4.2 works fine but in
1.4.3 returns bad value.
Comment 1 kaliber 2005-03-24 18:07:08 UTC 
Created attachment 39211 [details]
test case for sumif
Comment 2 Morten Welinder 2005-03-24 18:35:46 UTC 
Sheet1!$A$1:$A$3 in Sheet2 looks like a 3D reference to Gnumeric.

jody: when looking at the 'b' cell in the range, should we default the sheet to
the effective sheet of the 'a' cell?
Comment 3 Morten Welinder 2005-03-24 21:56:33 UTC 
Whatever the answer is, it probably applies to COUNTIF too.
Comment 4 Jody Goldberg 2005-03-27 02:49:03 UTC 
I see the problem.  The error test for 3d refs is being over zealous.
simple fix for both sum and countif.
Comment 5 Jody Goldberg 2005-04-04 05:11:02 UTC 
Patch is now in head and gnumeric-1-4