I need to fill out G12:G14 in tab "Lender Loan Tape Summary". I need to calculate the % of: total loan amount (col. P, "Historical Loan Tapes"), in the most frequent states (G9:G11), divided by the total loan amount. This needs to be referenced by Lender in cell B4 of "Lender Loan Tape Summary" tab. % of (loans originated in these states/total originated volume by lender)
Solved by B. C. in 24 mins