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