I need help writing a formula to do a weighted average base on multiple criteria. I have 4 main columns. Below is an small sample with dummy data. I really have about 500+ records.
Marginal Revenue (bps) | Product Code | Trade Month | Loan Amt |
.34 | C30 | 1511| 150,000
.36 | C30 | 1511| 190,000
.31 | C30 | 1508| 150,000
.50 | C30 | 1511| 140,000
.34 | C15 | 1510| 150,000
.36 | C30 | 1511| 190,000
.31 | C20 | 1512| 150,000
.50 | C30 | 1511| 140,000
I need to do a weighted average based on marginal revenue and loan amt. However, I must meet the criteria listed below.
Product Code=C30 & Trade Month=1511
Thanks in advance!!!!
Marginal Revenue (bps) | Product Code | Trade Month | Loan Amt |
.34 | C30 | 1511| 150,000
.36 | C30 | 1511| 190,000
.31 | C30 | 1508| 150,000
.50 | C30 | 1511| 140,000
.34 | C15 | 1510| 150,000
.36 | C30 | 1511| 190,000
.31 | C20 | 1512| 150,000
.50 | C30 | 1511| 140,000
I need to do a weighted average based on marginal revenue and loan amt. However, I must meet the criteria listed below.
Product Code=C30 & Trade Month=1511
Thanks in advance!!!!