How to find duplicate accounts being taken in different SUMIFS

I have an excel file with two sheets:
1. data imported from SQL with the columns: Group, Account, Balance
2. a sheet with lots of SUMIFS formulas that sometimes sum based on an account and sometimes based on a group.
This is intentional like this, because a group can contain 100+ accounts (and more are being added/removed constantly)

It could be then that one account will appear in two SUMIFS, because it is once taken in a SUMIFS with a group and once with a SUMIFS with an account.

How can I find those?

Thanks

Perhaps it would be useful if you could post a sample workbook with example data.

BSB

Ok. I added a sample excel.

Have a look at the section I've added to the attached. It uses COUNTIFS to create a matrix of which Groups and Accounts pertain to each other.
The blue section contains details of those Groups and Accounts in your summary.

If the intersecting value is 0 then there is no overlap. If it's greater than zero then there is some overlap, i.e. being counted twice in the summary.

Not sure if that's any help to you, but it works.

BSB

Hmm.. I am trying to figure out what you did You say if it's greater than 0 there's overlap, but there's overlap on every account then.. which is not true. also in your formulas you are not looking at the SUMMARY part at all..

BadlySpelledBuoy?