Dear Gurus,
Here is a situation I am struggling with:
ACTIVITY Main Main_Type Account Description Period Balance
A0000300 1501 BS Notes Receivable $147,576.40
A0000300 7603 Act Collection Costs $405.66
A0000300 4708 Act Loan Fund Interest ($5.53)
A0000300 4708 Act Loan Fund Interest ($2.41)

On another worksheet, I would like to sum from this table for "ACTIVITY" codes, where the "Main" number is higher than 5000.
So if on the other sheet, there is code A0000300, add up all the amounts where the Main number in this table is above 5000; therefore in this example the sum would be 405.66.

Thank you very much for the help.