Spreadsheet: 746594d1630881877-trying-to-pull-another-cell-in-a-range-if-this-cell-the-same-number-test
Sheet: Sheet1

Campaign | Campiagn Spend | Number of Leads |  |  | Number of Deals |  |  | Deals Per a Team |  |  | Number of Teams |  | 1 | Average Loan Amount |  | 300000 | Average Comission
 |  | Annual | Quarterly | Monthly | Annual | Quarterly | Monthly | Annual | Quarterly | Monthly | Total Annual GCI | [NAME] | Team | Revenue | Manager | Overide $ | Mortgage Company
US Credit Repair |  | 1800 | 450 | 150 | 18 | 6 | 1.5 | 18 | 6 | 1.5 | 108000 | 0.01 | 0.325 | 35100 | 0 | 0 | 0.675
Monthly spend Per a Team | 375 | 1800 | 450 | 150 | 90 | 30 | 7.5 | 90 | 30 | 7.5 | 540000 | 0.05 | 0.325 | 175500 | 0 | 0 | 0.675
Monthly Total Spend | 375 | 1800 | 450 | 150 | 144 | 48 | 12 | 144 | 48 | 12 | 864000 | 0.08 | 0.325 | 280800 | 0.05 | 43200 | 0.625
Cost Per Lead | 2.5 | 1800 | 450 | 150 | 216 | 72 | 18 | 216 | 72 | 18 | 1296000 | 0.12 | 0.325 | 421200 | 0.05 | 64800 | 0.625
Annual Leads Per Team | 1800 | 1800 | 450 | 150 | 315 | 105 | 26.25 | 315 | 105 | 26.25 | 1890000 | 0.175 | 0.325 | 614250 | 0.05 | 94500 | 0.625
Text Message Campaign |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.325 | 0 | 0 | 0 | 0.675
Monthly spend Per a Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.325 | 0 | 0 | 0 | 0.675
Monthly Total Spend | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.325 | 0 | 0.05 | 0 | 0.625
Cost Per Lead | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.325 | 0 | 0.05 | 0 | 0.625
Annual Leads Per Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.175 | 0.325 | 0 | 0.05 | 0 | 0.625
Direct Mail |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.325 | 0 | 0 | 0 | 0.675
Monthly spend Per a Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.325 | 0 | 0 | 0 | 0.675
Monthly Total Spend | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.325 | 0 | 0.05 | 0 | 0.625
Cost Per Lead | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.325 | 0 | 0.05 | 0 | 0.625
Annual Leads Per Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.175 | 0.325 | 0 | 0.05 | 0 | 0.625
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.325 | 0 | 0 | 0 | 0.675
Monthly spend Per a Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.325 | 0 | 0 | 0 | 0.675
Monthly Total Spend | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.325 | 0 | 0.05 | 0 | 0.625
Cost Per Lead | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.325 | 0 | 0.05 | 0 | 0.625
Annual Leads Per Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.175 | 0.325 | 0 | 0.05 | 0 | 0.625
Solar Credit Inquiries |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.325 | 0 | 0.05 | 0 | 0.625
Monthly spend Per a Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.325 | 0 | 0.05 | 0 | 0.625
Monthly Total Spend | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.325 | 0 | 0.05 | 0 | 0.625
Cost Per Lead | 65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.325 | 0 | 0.05 | 0 | 0.625
Annual Leads Per Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.175 | 0.325 | 0 | 0.05 | 0 | 0.625
Live Transfers |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.325 | 0 | 0.05 | 0 | 0.625
Monthly spend Per a Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.325 | 0 | 0.05 | 0 | 0.625
Monthly Total Spend | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08 | 0.325 | 0 | 0.05 | 0 | 0.625
Cost Per Lead | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.325 | 0 | 0.05 | 0 | 0.625
Annual Leads Per Team | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.175 | 0.325 | 0 | 0.05 | 0 | 0.625
Total |  | 1800 | 450 | 150 | 18 | 6 | 1.5 | 18 | 6 | 1.5 | 108000 | 0.01 | 35100 |  | 0 |  | 72900
Monthly spend Per a Team | 375 | 1800 | 450 | 150 | 90 | 30 | 7.5 | 90 | 30 | 7.5 | 540000 | 0.05 | 175500 |  | 0 |  | 364500
Monthly Total Spend | 375 | 1800 | 450 | 150 | 144 | 48 | 12 | 144 | 48 | 12 | 864000 | 0.08 | 280800 |  | 43200 |  | 540000
Cost Per Lead | 64.58 | 1800 | 450 | 150 | 216 | 72 | 18 | 216 | 72 | 18 | 1296000 | 0.12 | 421200 |  | 64800 |  | 810000
Annual Leads Per Team | 1800 | 1800 | 450 | 150 | 315 | 105 | 26.25 | 315 | 105 | 26.25 | 1890000 | 0.175 | 614250 |  | 94500 |  | 1181250