Bank Name	City	State	Closing Date
Citizens Bank of Northern California	Nevada City	CA	23-Sep-11
San Luis Trust Bank, FSB	San Luis Obispo	CA	18-Feb-11
Charter Oak Bank	Napa	CA	18-Feb-11
Canyon National Bank	Palm Springs	CA	11-Feb-11
First Vietnamese American Bank	Westminster	CA	5-Nov-10
Western Commercial Bank	Woodland Hills	CA	5-Nov-10
Sonoma Valley Bank	Sonoma	CA	20-Aug-10
Los Padres Bank	Solvang	CA	20-Aug-10
Butte Community Bank	Chico	CA	20-Aug-10
Pacific State Bank	Stockton	CA	20-Aug-10
Granite Community Bank, NA	Granite Bay	CA	28-May-10
1st Pacific Bank of California	San Diego	CA	7-May-10
Tamalpais Bank	San Rafael	CA	16-Apr-10
Innovative Bank	Oakland	CA	16-Apr-10
La Jolla Bank, FSB	La Jolla	CA	19-Feb-10
First Regional Bank	Los Angeles	CA	29-Jan-10
First Federal Bank of California, F.S.B.	Santa Monica	CA	18-Dec-09
Imperial Capital Bank	La Jolla	CA	18-Dec-09
Pacific Coast National Bank	San Clemente	CA	13-Nov-09
United Commercial Bank	San Francisco	CA	6-Nov-09
Pacific National Bank	San Francisco	CA	30-Oct-09
California National Bank	Los Angeles	CA	30-Oct-09
San Diego National Bank	San Diego	CA	30-Oct-09
San Joaquin Bank	Bakersfield	CA	16-Oct-09
Affinity Bank	Ventura	CA	28-Aug-09
Temecula Valley Bank	Temecula	CA	17-Jul-09
Vineyard Bank	Rancho Cucamonga	CA	17-Jul-09
Mirae Bank	Los Angeles	CA	26-Jun-09
MetroPacific Bank	Irvine	CA	26-Jun-09
First Bank of Beverly Hills	Calabasas	CA	24-Apr-09
County Bank	Merced	CA	6-Feb-09
Alliance Bank	Culver City	CA	6-Feb-09
1st Centennial Bank	Redlands	CA	23-Jan-09
PFF Bank & Trust	Pomona	CA	21-Nov-08
Downey Savings & Loan	Newport Beach	CA	21-Nov-08
Security Pacific Bank	Los Angeles	CA	7-Nov-08
First Heritage Bank, NA	Newport Beach	CA	25-Jul-08
IndyMac Bank	Pasadena	CA	11-Jul-08
Southern Pacific Bank	Torrance	CA	7-Feb-03
use the proper formula to count the number of banks in California that utilized the mortgage to the customers.
Use the filter function to show only banks in California