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