I have a pair of simple SUMIF statements that check for values in another sheet. One cell sums values from the other sheet that are currency and a cell right next to it sums values that are whole numbers (not currency). The criteria is the same for both formulas.

When I go to the sheet where the values to be summed exist, the results for the whole numbers calculation changes based on what is filtered (row 1). I can't narrow it down to what gets included and excluded. All I know is when nothing is filtered, I get the correct results. But if I go and filter any column, not even one in the formula, I get different results. Only the whole number SUMIF results change. The summed dollar results stay the same regardless of what is filtered. It seems like it should work the way the dollar SUMIF is working.

Is this a bug? Is there a way to get around it?