Spreadsheet: 689426d1596391712-sumif-trouble-excel-forum_sample
Sheet: Sheet1

 | Reference Data #1 |  |  | Reference Data #2
 | County | 2019 |  | MSA | County in MSA |  | MSA unique | Total in county
 | Alameda | 9578 |  | Los Angeles-Long Beach-Anaheim, CA | Los Angeles |  | Los Angeles-Long Beach-Anaheim, CA
 | Amador | 655 |  | Los Angeles-Long Beach-Anaheim, CA | Orange |  | Riverside, CA
 | [NAME] | 2120 |  | Riverside, CA | Riverside |  | Ventura, CA
 | Calaveras | 1116 |  | Riverside, CA | San Bernardino |  | San Francisco, CA
 | Contra-Costa | 10103 |  | Ventura, CA | Ventura |  | San Jose, CA
 | [NAME] | 209 |  | San Francisco, CA | Alameda |  | Stockton, CA
 | El Dorado | 3091 |  | San Francisco, CA | Contra Costa |  | Modesto, CA
 | Fresno | 8040 |  | San Francisco, CA | San Francisco |  | Santa Rosa, CA
 | [NAME] | 227 |  | San Francisco, CA | San Mateo |  | Vallejo, CA
 | Humboldt | 1335 |  | San Francisco, CA | Marin |  | Merced, CA
 | Kern | 5873 |  | San Jose, CA | Santa Clara |  | Santa Cruz, CA
 | Kings | 1119 |  | San Jose, CA | San Benito |  | Napa, CA
 | Lake | 808 |  | Stockton, CA | San Joaquin |  | San Diego, CA
 | [NAME] | 285 |  | Modesto, CA | Stanislaus |  | Sacramento, CA
 | Los Angeles | 37941.67055524509 |  | Santa Rosa, CA | Sonoma |  | Yuba City, CA
 | Madera | 1806 |  | Vallejo, CA | Solano |  | [NAME], CA
 | Marin | 2114 |  | Merced, CA | Merced |  | Fresno, CA
 | Mariposa | 178 |  | Santa Cruz, CA | Santa Cruz |  | Madera, CA
 | Mendocino | 617 |  | Napa, CA | Napa |  | Hanford, CA
 | Merced | 1601 |  | San Diego, CA | San Diego |  | Bakersfield, CA
 | Mono | 148 |  | Sacramento, CA | Sacramento |  | Visalia, CA
 | [NAME] | 2443 |  | Sacramento, CA | Placer |  | Santa Maria-Santa Barbara, CA
 | Napa | 1136 |  | Sacramento, CA | Yolo |  | Salinas, CA
 | Nevada | 1466 |  | Sacramento, CA | El Dorado |  | [NAME], CA
 | Orange | 16922 |  | Yuba City, CA | Sutter |  | Redding, CA
 | Placer | 5755 |  | Yuba City, CA | [NAME] |  | Red Bluff, CA
 | Plumas | 382 |  | [NAME], CA | Nevada |  | Chico, CA
 | Riverside | 22887 |  | Fresno, CA | Fresno |  | El Centro, CA
 | Sacramento | 16099 |  | Madera, CA | Madera |  | [NAME], CA
 | San Benito | 553 |  | Hanford, CA | Kings |  | Ukiah, CA
 | San Bernardino | 13837 |  | Bakersfield, CA | Kern |  | Clearlake, CA
 | San Diego | 22180 |  | Visalia, CA | Tulare |  | Sonora, CA
 | San Francisco | 2115 |  | Santa Maria-Santa Barbara, CA | Santa Barbara |  | Susanville, CA
 | San Joaquin | 6612 |  | Salinas, CA | [NAME] |  | Crescent City, CA
 | [NAME] | 3115 |  | [NAME], CA | [NAME] |  | None
 | San Mateo | 3945 |  | Redding, CA | Shasta
 | Santa Barbara | 2708 |  | Red Bluff, CA | [NAME]
 | Santa Clara | 9225 |  | Chico, CA | [NAME]
 | Santa Cruz | 1637 |  | El Centro, CA | Imperial
 | Shasta | 2989 |  | [NAME], CA | Humboldt
 | Siskiyou | 501 |  | Ukiah, CA | Mendocino
 | Solano | 4305 |  | Clearlake, CA | Lake
 | Sonoma | 4097 |  | Sonora, CA | Tuolumne
 | Stanislaus | 5182 |  | Susanville, CA | [NAME]
 | Sutter | 832 |  | Crescent City, CA | [NAME]
 | [NAME] | 565 |  | None | Calaveras
 | Tulare | 3548 |  | None | Siskiyou
 | Tuolumne | 817 |  | None | Amador
 | Ventura | 5078 |  | None | [NAME]
 | Yolo | 1533 |  | None | Colusa
 | [NAME] | 916 |  | None | Plumas
 |  |  |  | None | Inyo
 |  |  |  | None | Mariposa
 |  |  |  | None | Mono
 |  |  |  | None | Trinity
 |  |  |  | None | Modoc
 |  |  |  | None | Sierra
 |  |  |  | None | Alpine