Niek,

I disagree with your statement about the "criteria range." If I put a "x"
in the range, the sum changes. If I delete that "x", the sum changes again.



"Niek Otten" wrote:

There seems to be a difference in specifications. I could only test Excel 2003 and 2007.
In Excel 2007, the criteria range has to be numeric. Blank and text cells are ignored. This was not the case in earlier Excel
versions.

I don't know if this should be considered a bug, but it certainly is an incompatibility!

Probably some of your evaluation cells are blank or spaces, while others are zero. Can you confirm that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"FAI_Judge" wrote in message ...
| There seems to be a major bug in Excel. I open a spreadsheet in Office 2000
| Excel and a conditonal sum gives a correct answer. Open the same speadsheet
| in Excel 2007 and the formula gives another sum. In Excel 2007 if I copy
| that part of the sheet to a new sheet it returns the correct sum. The
| formula is of the form
|
| =sumif(a50:a67,"<x",e50:e67)
| sum in Excel 2000 = 315
| sum in Excel 2007 = 290
|
| Column a50:a67 is empty (has been deleted). If I highlight column e50:e67
| in Excel 2007 the sum on the status bar is correct (315).
|
| Anyone had this problem?