GNOME Bugzilla – Bug 586215
Sumif (etc) do not understand wildcards
Last modified: 2009-06-20 19:36:51 UTC
Please describe the problem: In excel this works: =sumif(RANGE,"VALUE*",RANGE) but it does not work in gnumeric so: A B 1 07 50 2 ML 52 3 07 47 4 07 48 =sumif(A1:A4,"0*",B1:B4) should work Steps to reproduce: 1. 2. 3. Actual results: Expected results: Does this happen every time? Other information:
What do you get and what do you expect to get?
I think I see the problem. We do not support the matching versions of criteria, i.e., the ones with "*" and "?" in them.
It shouldn't be that hard to implement, I can look at it if you point me in the right direction. Most sumif information online has this matching criteria. This and the array formula find bug are the only thing keeping me from using gnumeric.
src/value.c function parse_criteria is a good start. I'll get around to it.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.