First trial, in cell Q7. The result isn't quite what you have but it looks close

Attached Files

Copy of Book2v2.xlsx (52.9 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thank you for your help! I actually was able to get it to work with my SUMIF function. Here is that argument.

=SUMIFS('Shareholder Transactions'!G:G,'Shareholder Transactions'!A:A,'Trial Balance'!C7,'Shareholder Transactions'!E:E,">"&'Trial Balance'!B7)