Sumifs or Index Match

I am having trouble with a sumifs formulas and wondering is index match or another formulas may be better suited. I have attached an example for reference. The data tab pulls in info from the TB tabs. The lines highlighted in red on the data tab are not pulling the needed info from the TB tabs using the sumifs formulas and cant figure out why not?

Your account numbers on the TB tabs are preceded by 5 spaces, whereas the account numbers on Data that you're trying to pair against them are not. An easy approach would be to change your SUMIFS on Data to:

=SUMIFS(actmo, actacct," "&E4) <--with 5 spaces between the quotation marks

...in F4 if you're sure that there will always be exactly 5 preceding spaces. Alternatively, you could use something like:

=SUMIFS(actmo, actacct,"*"&E4)

If you'd prefer to use a wildcard rather than the 5 spaces. The danger there is that you might run into trouble if one of your acct. numbers is contained within another. For instance, the wildcard will view both 123.45 and 5123.45 as satisfying the IF condition.