I think you are not getting the result because your SUMIF does not contain the correct arguments.
A SUMIF asks for the following arguments
>Range, >Criteria, SumRange
>Range: This is the range that the SUMIF will search for the next argument of >Criteria. So when the Criteria is met it will sum the next argument >SumRange.
In order to accomplish the desired result this would be the formula to put into cell B2 on your totals page.
Code:
=SUMIF('Check Register'!D:D,'TOTALS'!A2,'CHECK REGISTER'!G:G)
Once this formula is written you can copy and paste it to the other rows. the $ signs are not needed since you are only adapting the formula to rows and not columns.
Let me know if this fixes the issue or if you have any other questions.
Thanks