Anyone have Excel calculation error issues?

[sportsguy]

I have a sumif formula which is not calculating a correct answer at all,
and its not a very big spreadsheet. . .

and yes, I have been using sumif formulas for years successfully. . .

but this answer isn't even close, with auto calculation turned on

sportsguy

[Paul]

Hi Sportsguy, can you upload the spreadsheet in question? In it, point out which formula is incorrectly reporting totals and what it should be showing as the result.