Maybe I stated the problem incorrectly in the original post. If you
highlight the cells a50:a67 and press "delete" the sum of e50:e67 is 290. If
I then fill cells a50:a67 with x the sum is 0. If I then delete the x in
cells a50:a67 the sum is 315. Not good.


"FAI_Judge" wrote:

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?