Posts by thefosh1984

    Re: Totals changing despite sumif


    Hi Callum,


    Thank you for getting back to me. The problem is that i don't want the totals to change on the totals tab. This should be a total for the whole company despite what filters are on in the input tab.


    thank you


    Kieron

    Hi everyone,


    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?


    thank you


    Kieron