Sum total doesn't add up when copied to another sheet

I'm looking forward to someone pointing out my obvious mistake here. I've filtered my main budget sheet to show different notional budgets then copied those cells into seperate tabs on a new sheet.

The totals from each tab are totalled on the front tab of the new Notional Budgets sheet - these should add up to the total from the main budget sheet but it's out by £172

I've checked and there don't appear to be any missing lines. both sheets are attached below - can you let me know my stupid mistake please

Just to confirm - the total budget of £157,629 should be different from total notional budget of £120,000 but the spend to date on both worksheets should be exactly the same information

OK nevermind, disregard the whole thing, I have clearly been looking at this too long and didn't spot that one of the VAT sums had a reference to a different sheet for some reason - all seems to work now. I knew it would be something stupid that I was sure I had already checked

well spotted! It's because we received money back from external partner organisations, didn't record that but had to show the full amount of spend (row 5)...

That's why the grand total in red is the sum of the totals of C and D

I'm also working with a bunch of numpties who don't know to record VAT.....
and not all orders incur VAT

yes it's solved thanks, think I must have copied a sum from a different sheet and not noticed/checked it properly

no option to choose anything - Edit just gives me a blank entry.... I'll try pasting my original blurb into it

Click on Thread Tools just above your first post, then you can select SOLVED.

Hope this helps.

Pete

sorted, thanks all