Spreadsheet: 842374d1694467266-if-and-return-value-based-on-2-sets-of-conditions-sample
Sheet: 2023 Spons Sales (CVS)

Month | # of Sales | Account Manager | Date of First Payment | BID | Business Name | County | Amount Total | Foundation Funds | Comm. Sheet Added | contact | Contract or recording | purchased in contract | Blue URL | New GN (Listing) | Renewal GN (Listing) | Payment Type (F, M, Q, S) | New SP | Renewal SP | Payment Type (F, M, Q, S) | Value | 2018 | 2019 | 2020 | 2021 | 2022 | New Money | New Sponsors | Dues Included/ Amount | Cancelled/Money Not Collected
August | 1 | OC Split | 2022-08-03 00:00:00 | 100089817 | 1st Choice Design & Development | San Diego | 5012 |  | 2023-09-05 00:00:00 | [NAME] | Yes | Tier 1 listing |  |  | 5012 | M |  |  |  | 0 |  |  |  | 5012 | 5012
August | 1 | Alexis | 2023-08-01 00:00:00 | 1000077936 | Indigo Remodels LLC | Maricopa | 2000 |  | 2023-09-05 00:00:00 | [NAME] | yes | 5th [NAME] | https://bluebbb.org/core/manage/?firm=[PHONE] | 2000 |  | M |  |  |  |  |  |  |  |  |  | 2000 | 1
Aug | 1 | Brett | 2023-08-02 00:00:00 | 1000113679 | Us Plumbing | San Diego | 1500 |  | 2023-09-05 00:00:00 | [NAME] | Yes | [NAME] | https://bluebbb.org/core/manage/?firm=[PHONE] | 1500 |  | M |  |  |  |  |  |  |  |  |  | 1500 | 1500
August | 1 | [NAME] | 2023-08-02 00:00:00 | 16003191 | Aquatech Raingutters | San Diego | 1500 |  | 2023-09-05 00:00:00 | [NAME] | yes | [NAME] |  |  | 1500 | M |  |  |  |  | 1500 |  |  | 1500 | 1500
August | 1 | [NAME] | 2023-08-04 00:00:00 | 9000550 | B & D Seamless Aluminum Rain Gutters | San Diego | 600 |  | 2023-09-05 00:00:00 | [NAME] | Yes | Tier 3 |  |  | 600 | M |  | M |  |  | 300 |  |  | 600 | 600
August | 1 | [NAME] | 2023-08-04 00:00:00 | 32003182 | [NAME] Patio Covers | San Diego | 600 |  | 2023-09-05 00:00:00 | Noah Bauers | Yes | Tier 5 |  |  | 600 | M |  | M |  |  |  |  |  | 600 | 600
August | 1 | Alexis | 2023-08-07 00:00:00 | 1000113469 | The Queen's Corn LLC | Maricopa | 1400 |  | 2023-09-05 00:00:00 | [NAME] | yes | 10/23 Billboard- Cave Creek Claire | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  | 1400 |  | F |  |  |  |  |  |  | 1400 | 1
August | 1 | [NAME] | 2023-08-07 00:00:00 | 1000098965 | SB Woodworking | San Diego | 360 |  | 2023-09-05 00:00:00 | Sergio Estrada | Yes | Web Hosting |  |  |  |  |  | 360 | F
Aug | 1 | Brett | 2023-08-08 00:00:00 | 1000107701 | JME Plumbing Inc | Orange County | 1000 |  | 2023-09-05 00:00:00 | Josue M Escobedo | Paid in full | Business Listings | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  | 1000 |  | F |  |  |  |  |  |  | 1000 | 1000
August | 1 | Alexis | 2023-08-10 00:00:00 | 9002545 | Prime Wealth Advisors | Maricopa | 4000 |  | 2023-09-05 00:00:00 | [NAME] | yes | 2nd Tier Financial | https://bluebbb.org/core/manage/?firm=9002545 |  | 4000 | M
August | 1 | Alexis | 2023-08-10 00:00:00 | 1000067661 | [NAME] | Maricopa | 3000 |  | 2023-09-05 00:00:00 | [NAME] | yes | 2nd Tier Landscaping Contractor | https://bluebbb.org/core/manage/?firm=[PHONE] | 3000 |  | M |  |  |  |  |  |  |  |  |  | 3000 | 1
August | 1 | [NAME] | 2023-08-10 00:00:00 | 1057863 | Charles Tree Service | San Diego | 600 |  | 2023-09-05 00:00:00 | [NAME] | Yes | Tier 5 |  |  | 600 | M |  | M |  |  |  |  |  | 600 | 600
August | 1 | Kelsey | 2023-08-11 00:00:00 | 23001285 | California Coast Credit Union | San Diego | 1650 |  | 2023-09-05 00:00:00 |  |  | dues/5th tier |  |  |  |  |  | 1650 | F | 1650
August | 1 | [NAME] | 2023-08-11 00:00:00 | 100609 | Carlsbad Auto Service | San Diego | 840 |  | 2023-09-05 00:00:00 | [NAME] | Yes | Tier 3 |  |  | 840 | M |  | M |  |  |  |  |  | 840 | 840
August | 1 | [NAME] | 2023-08-14 00:00:00 | 2746 | Coulter Nissan | Maricopa | 3000 |  | 2023-09-05 00:00:00 |  |  | dues + tier 3 |  |  |  |  |  | 3000 | f |  |  |  |  |  | 3000
Aug | 1 | Brett | 2023-08-14 00:00:00 | 1000060030 | D & L Builders Inc | San Diego | 10000 |  | 2023-09-05 00:00:00 | [NAME] |  | [NAME] for 2 TOB's | https://bluebbb.org/core/manage/?firm=[PHONE] | 10000 |  | M |  |  |  |  |  |  |  |  |  | 10000 | 10000
August | 1 | Kelsey | 2023-08-15 00:00:00 | 36005886 | Cash Time Loan Centers | Maricopa | 2700 |  | 2023-09-05 00:00:00 |  | yes | 5th tier/dues |  |  |  |  |  | 2700 | M | 2700 |  |  |  |  |  |  |  | 1200
August | 1 | [NAME] | 2023-08-15 00:00:00 | 16000344 | Weissler Law Group | San Diego | 1500 |  | 2023-09-05 00:00:00 | [NAME] | Yes | Tier 5 Plus RR banner (Bump to Tier 1 Estate Planning) |  |  |  |  |  | 1500 | M |  |  | 1300 |  | 1500 | 1500
August | 1 | [NAME] | 2023-08-16 00:00:00 | 1000040692 | Umphress Truck N Trailer Repair | Yuma | 1000 |  |  |  | yes | get noticed, social, dues |  |  |  |  |  | 1000 | m |  |  | 1000 | 1000 | 1000 | 1000
August | 1 | Kelsey | 2023-08-17 00:00:00 | 1000019902 | MY AUTOMAN | Maricopa | 1500 |  |  |  | yes | power listings/dues |  |  |  |  |  | 1500 | M
August | 1 | Split (Kelsey, [NAME]) | 2023-08-17 00:00:00 | 97002593 | Sunland Environmental Testing | Maricopa | 3500 |  |  |  |  | 3rd tier, dues |  |  |  |  |  | 3500 | M | 3500 |  |  |  |  |  |  |  | 564
August | 1 | [NAME] | 2023-08-17 00:00:00 | 171988830 | Empire Garage Doors | San Diego | 3000 |  |  | [NAME] | Yes | Tier 3 |  |  | 3000 | M |  | M |  |  |  |  |  | 3000 | 3000
August | 1 | Kelsey | 2023-08-18 00:00:00 | 1000001542 | EZ Flow Plumbing | Maricopa | 4500 |  |  |  | yes | bottom banner/4th tier |  |  |  |  |  | 4500 | M
Aug | 1 | Brett | 2023-08-18 00:00:00 | 1000063719 | Stella Moving & Delivery San Diego | San Diego |  | 1125 |  | Arslan "Mathew" Turganov | Paid in full | Torch Awards - SD - Table Sponsor $1,000 | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 1125 | f
August | 1 | [NAME] | 2023-08-18 00:00:00 | 14000845 | At Your Home Familycare | San Diego | 2200 |  |  | [NAME] | Yes | Tier 1 |  |  | 2200 | M |  | M |  |  |  |  |  | 2200 | 2200
August | 1 | OC Split | 2023-08-19 00:00:00 | 100089817 | 1st Choice Design & Development | Orange | 5012 |  |  |  | Yes | Tier 1 listing |  |  | 5012 | M |  |  |  | 0 |  |  |  | 5012 | 5012
August | 1 | [NAME] | 2023-08-22 00:00:00 | 1000006250 | Rentals America | Maricopa | 3000 |  |  |  |  | tier 2 |  |  | 3000 | M |  |  |  |  |  |  |  |  | 3000
August | 1 | Kelsey | 2023-08-22 00:00:00 | 100017572 | American Advisors Group | San Diego | 1500 |  |  |  |  | dues/5th tier |  |  |  |  |  | 1500 | F
August | 1 | Kelsey | 2023-08-23 00:00:00 | 1000111222 | Gila Cabinet & Stone | Maricopa | 3000 |  |  |  | yes | 3rd tier stone/cabinets |  | 3000 |  | M
August | 1 | Alexis | 2023-08-23 00:00:00 | 1000113426 | OCD Construction | Maricopa | 6000 |  |  | [NAME] | yes | 1st [NAME] | https://bluebbb.org/core/manage/?firm=[PHONE] | 6000 |  | M |  |  |  |  |  |  |  |  |  | 6000 | 1
August | 1 | [NAME] | 2023-08-24 00:00:00 | 15003697 | True View Windows | Maricopa | 7000 |  |  |  |  | tier 3, dues, banners, targeted banner |  |  |  |  |  | 7000 | m |  |  |  |  |  | 7000
August | 1 | Alexis | 2023-08-25 00:00:00 | 1000045509 | Clean Environment LLC | Maricopa | 3000 |  |  | [NAME] | yes | 3rd Tier + Targeted | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 3000 | M
August | 1 | Alexis | 2023-08-25 00:00:00 | 1000085815 | Phoenix #1 Automotive LLC | Maricopa | 4000 |  |  | [NAME] | yes | 2nd Tier + 6 mo. Targeted | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 4000 | M
August | 1 | [NAME] | 2023-08-25 00:00:00 | 1000100956 | Be Carb Compliant | San Diego | 2120 |  |  | [NAME] | Yes | Accreditation, Yext & Web Hosting |  |  |  |  |  | 2120 | M |  |  |  |  |  |  | 5500 |  | Yes
August | 1 | [NAME] | 2023-08-25 00:00:00 | 1044170 | Brothers Home Improvement | San Diego | 3000 |  |  | [NAME] | Yes | Tier 2 & RR Banner |  |  |  |  |  | 3000 | M |  |  | 3600 |  | 3000 | 3000
August | 1 | [NAME] | 2023-08-27 00:00:00 | 101678 | [NAME] | San Diego | 1500 |  |  | [NAME] | No | Tier 5 |  |  | 1500 | M |  |  |  |  |  | 2300 |  | 1500 | 1500
August | 1 | Alexis | 2023-08-28 00:00:00 | 1000074161 | Absolute Insurance Solutions LLC | Maricopa | 3600 |  |  | Gef | yes | 3rd Tier + Targeted + Power Listing | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 3600 | M
August | 1 | Kelsey | 2023-08-29 00:00:00 | 1000110667 | Forefront Roofing | Orange | 4000 |  |  | Ari | yes | 3rd tier/targeted banner |  |  |  |  | 4000 |  | M | 4000 |  |  |  |  |  | 4000 | 1
August | 1 | Split (Alexis, Kelsey & Katie) | 2023-08-29 00:00:00 | 28051 | Reborn Cabinets | Orange | 1500 |  |  |  |  | [NAME] |  |  |  |  |  | 1500 | F | 1500 |  |  |  |  |  |  |  | 600
August | 1 | Split (Alexis, Kelsey, [NAME]) | 2023-08-29 00:00:00 | 172001653 | Smart Fares | San Diego | 1500 |  |  |  |  | tier 4 |  |  |  |  |  | 1500 | F
August | 1 | Kelsey | 2023-08-30 00:00:00 | 1000005891 | [NAME] Improvements | Maricopa | 4500 |  |  |  | yes | power listings/review solution/dues/2nd tier |  |  |  |  |  | 4500 | M | 4500
August | 1 | [NAME] | 2023-08-30 00:00:00 | 172002664 | All American Garage Doors | San Diego | 600 |  |  | [NAME] | Yes | Tier 5 |  |  | 600 | M |  |  |  |  | 600 |  |  | 600 | 600
August | 1 | OC Split | 2023-08-30 00:00:00 | 1000077998 | California Solar Installers | OC | 1500 |  |  |  | continuation | tier 3 listing |  |  | 1500 | M |  |  |  |  |  |  |  | 1500 | 1500
August | 1 | [NAME] | 2023-08-31 00:00:00 | 88002052 | Arizona Foundation Solutions | Maricopa | 1500 |  |  |  |  | tier 3 |  |  | 1500 | F
Aug | 1 | Brett | 2023-08-31 00:00:00 | 1000114475 | MDTech Services | Orange | 1000 |  |  | [NAME] | Paid in full | Business Listings | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  | 1000 |  | F |  |  |  |  |  |  | 1000 | 1000
Aug | 1 | Brett | 2023-08-31 00:00:00 | 1000091799 | [NAME] | San Diego | 2000
 |  |  |  |  |  |  | 5012 | Renewal GN (Listing)
 |  |  |  |  |  |  | 2000 | New GN (Listing)
 |  |  |  |  |  |  | 1500 | New GN (Listing)
 |  |  |  |  |  |  | 1500 | Renewal GN (Listing)
1. Copy and paste value from 2023 Spons Sales (CVS) from Google Doc |  |  |  |  |  |  | 600 | Renewal GN (Listing)
2. Delete all blanks in Column A |  |  |  |  |  |  | 600 | Renewal GN (Listing)
 |  |  |  |  |  |  | 1400 | New SP
 |  |  |  |  |  |  | 360 | Renewal SP
 |  |  |  |  |  |  | 1000 | New SP
 |  |  |  |  |  |  | 4000 | Renewal GN (Listing)
 |  |  |  |  |  |  | 3000 | New GN (Listing)
 |  |  |  |  |  |  | 600 | Renewal GN (Listing)
 |  |  |  |  |  |  | 1650 | Renewal SP
 |  |  |  |  |  |  | 840 | Renewal GN (Listing)
 |  |  |  |  |  |  | 3000 | Renewal SP
 |  |  |  |  |  |  | 10000 | New GN (Listing)
 |  |  |  |  |  |  | 2700 | Renewal SP
 |  |  |  |  |  |  | 1500 | Renewal SP
 |  |  |  |  |  |  | 1000 | Renewal SP
 |  |  |  |  |  |  | 1500 | Renewal SP
 |  |  |  |  |  |  | 3500 | Renewal SP
 |  |  |  |  |  |  | 3000 | Renewal GN (Listing)
 |  |  |  |  |  |  | 4500 | Renewal SP
 |  |  |  |  |  |  | 0 | Renewal SP
 |  |  |  |  |  |  | 2200 | Renewal GN (Listing)
 |  |  |  |  |  |  | 5012 | Renewal GN (Listing)
 |  |  |  |  |  |  | 3000 | Renewal GN (Listing)
 |  |  |  |  |  |  | 1500 | Renewal SP
 |  |  |  |  |  |  | 3000 | New GN (Listing)
 |  |  |  |  |  |  | 6000 | New GN (Listing)
 |  |  |  |  |  |  | 7000 | Renewal SP
 |  |  |  |  |  |  | 3000 | Renewal SP
 |  |  |  |  |  |  | 4000 | Renewal SP
 |  |  |  |  |  |  | 2120 | Renewal SP
 |  |  |  |  |  |  | 3000 | Renewal SP
 |  |  |  |  |  |  | 1500 | Renewal GN (Listing)
 |  |  |  |  |  |  | 3600 | Renewal SP
 |  |  |  |  |  |  | 4000 | New SP
 |  |  |  |  |  |  | 1500 | Renewal SP
 |  |  |  |  |  |  | 1500 | Renewal SP
 |  |  |  |  |  |  | 4500 | Renewal SP
 |  |  |  |  |  |  | 600 | Renewal GN (Listing)