GNOME Bugzilla – Bug 417305
sumif function does not seem to work properly
Last modified: 2008-03-27 23:51:53 UTC
Please describe the problem: on the first sheet there is table data in the following format: a b c d Date1 Date2 Value date1&date2 On the third sheet I have a sumif function Sumif(sheet1!d:d,dateA&dateB,Sheet1!c:c) The function returns 0, when I know it should not be 0. I tried changing formulas in various ways such as Sumif(sheet1!d:d,"="&dateA&dateB,Sheet1!c:c) and it did not make any difference Steps to reproduce: 1. see the example above 2. 3. Actual results: Expected results: Does this happen every time? Other information: i had to use vlookup
It would be helpful if you could create a test file and tell us what result you expect in what cell.
Closing due to lack of info. Feel free to reopen if more arrives.
Created attachment 108092 [details] This atachment demonstrates the problem
I get 5 with a current, but unreleased, Gnumeric. (See bug 523250, though.) What do you get and what version are you using now?
In 1.8.0 it yields 0
I have version 1.6.3. I get 0 as well.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report. This is the same interpretation issue as bug 523250. Note, however that what you do is very, very fragile. You take two numbers, say "19" and "1", and put them right after each other and get "191". Don't be surprised that if you search for "1" and "91" you will get a match. The fix will be in 1.8.3 *** This bug has been marked as a duplicate of 523250 ***
Thank you all