i have a spreadsheet that contains simple sumif formulas and then has a summary tab that contains the same to create a consolidated position. The trouble is, when I filter on the input tab, this changes the totals tab! I have never know this for sumifs. I am a fairly advanced user of Excel (able to write and interpret VBA level) but I am perplexed by this because it has never happened before. Has anyone else experienced this?