Created Sumifs formula but doesnt work when table is sorted

[batjl9]

Hi

Ive attached a file. It has an 'accounts' tab that stores data that I update daily. It is linked to another tab ' Daily Difference' which has same data stored but on complete sheet it has a few more details. I have set a sumifs formula so that if todays total on 'accounts' tab changes, it will update in he table in 'daily difference'. At the moment i have a sumifs formula that works but as soon as i sort the data in the ' accounts ' tab it stops working. is there a formula to use so that i can sort the date in 'accounts' tab table and it still updates correctly in 'daily difference' tab?

thanks in advance
Julie

[Fluff13]

How about

Please Login or Register  to view this content.

[batjl9]

Thanks for your help that works perfectly now.

[Fluff13]

Glad to help & thanks for the feedback.