I just upgraded to Excel 2010 (it was free since I bought 2009 recently). I now do not have another version of excel to test it, but I think I recognized the SUMIF error. Now I know that the probability that I found an error in excel is almost zero, so can someone tell me what I'm doing wrong, or, alternatively, tell me what their version of Excel does?
- Open a blank book
- In sheet 1, put 1 (number only) in cells C1-D3 (6 cells - the exact number does not matter)
- In sheet 2, put 2,3 and 4 in cells D1, D2 and D3, respectively
- Now in the cell in sheet2, enter the following formula
=SUMIF(Sheet1!D1:D3, 1, Sheet2!D1:D3) - In another cell in sheet2, put this formula
=SUMIF(Sheet1!C1:C3, 1, Sheet2!D1:D3)
As far as I see, the cells should display the same value, but in my excel version the first ones display 3 (wrong), and the second one displays 9 (correctly - the sum of 2,3 and 4)
Values 1,2,3 and 4 do not matter. The letters for the columns seem to match, which causes an error.
Before anyone can prove that Excel is not programming, I ask for a distinction.
[Since then, I found another bug report on the Technologists forum: http://social.technet.microsoft.com/Forums/en/excel/thread/cda9fef8-8ad4-4d56-8939-49b1ae50c4e7 - so it could be really]
source share