Good Day All!
There are millions of articles and helpers and i can't get anything to match with what my data is telling me i need to have. Nothing ever gives me a correct picture, or i'm just too dumb to be doing numbers. there's so many circular references i don't know how to separate the data.
I beg for help.
I need to sum the amount in Assigned Amount (D) when all instances of Tie Series(M) are found. For example account number 14, 65,159, may be the same "tie series" 12102. So I should get a total of $36,696.69.
sheet: accounts
Then I need to look in the transactions sheet and separate the Assigned Amount if there is a transaction code (B)= 300 with that matching account number. So i would have the 300 value to be 36,696.69, and the others would be excluded.
sheet: transactions
Hopefully this makes sense what i'm looking for and someone can provide help.
Please and thank you.
There are millions of articles and helpers and i can't get anything to match with what my data is telling me i need to have. Nothing ever gives me a correct picture, or i'm just too dumb to be doing numbers. there's so many circular references i don't know how to separate the data.
I beg for help.
I need to sum the amount in Assigned Amount (D) when all instances of Tie Series(M) are found. For example account number 14, 65,159, may be the same "tie series" 12102. So I should get a total of $36,696.69.
sheet: accounts
Account Number | Client Reference Number | Assign Date | Assigned Amount | Principal Due | fee Due | fee Paid | fee Total | Sts | Name1 | Client | Judgment Date | Tie Series | Trailer |
14 | 132 | 4/16/2014 | 6319.28 | 0 | 0 | 91.5 | 91.5 | PIF | smith,steve | old | 4/16/2014 | 12102 | 14 |
65 | 165 | 4/16/2014 | 5616.67 | 2611.45 | 25 | 13 | 38 | LGL | smith,steve | old | 12102 | 65 | |
159 | 1610 | 4/16/2014 | 24760.74 | 0 | 0 | 0 | 0 | LGL | smith,steve | old | 4/16/2014 | 12102 | 159 |
17 | 3 | 4/16/2014 | 13427.38 | 0 | 0 | 225 | 225 | PIF | jetson,george | old | 4/7/2014 | 12593 | 17 |
19 | 12 | 4/17/2014 | 14658.02 | 0 | 0 | 49 | 49 | PIF | jetson,george | old | 4/22/2014 | 12593 | 19 |
Then I need to look in the transactions sheet and separate the Assigned Amount if there is a transaction code (B)= 300 with that matching account number. So i would have the 300 value to be 36,696.69, and the others would be excluded.
sheet: transactions
Account Number | Transaction Code | Amount | Transaction Date | ACLIENT | HEADER |
14 | 300 | 76.96 | 12/16/2014 | old | 12102 |
17 | 1 | 25 | 12/16/2014 | old | 12593 |
Hopefully this makes sense what i'm looking for and someone can provide help.
Please and thank you.