Column a50:a67 is empty (has been deleted
Sure can't equal "x" then
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?