Figured it out. Here's my solution which just adds to your code Blake:
Blake, thank you so much for the help!
some of the variables were already defined before so not included in my solution code unless asked for!
import arcpy
import datetime
import os
mxd = arcpy.mapping.MapDocument("Current")
date = datetime.date.today()
unitedStatesBoundary = arcpy.mapping.ListLayers(mxd, 'United States Boundary')[0]
targetFeature = arcpy.mapping.ListLayers(mxd, 'Target Feature')[0]
mapName = str(mxd.filePath).split('\\')[-1:][0][:-4]
mapFolder = str(mxd.filePath)[:23]
saveLocFS = mapFolder
folderNameFS = "{} UG {} {}".format(mapName[0:7], mapName[8:], date)
df = arcpy.mapping.ListDataFrames(mxd)[0]
stats = []
statesFS = {6:'California'}
statesAbbreviationsFS = {6:'CA'}
statesCDCCode = {6:'California CDC Code'}
for state in statesFS:
valueStatesFS = dict.get(statesFS, state)
valueStatesAbbreviationsFS = dict.get(statesAbbreviationsFS, state)
valueCDCCode = dict.get(statesCDCCode, state)
unitedStatesBoundary.definitionQuery = "Name = '{}'".format(valueStatesFS)
arcpy.RefreshActiveView()
arcpy.SelectLayerByLocation_management(targetFeature,"intersect",unitedStatesBoundary,"","NEW_SELECTION")
mxd.save()
stateMapNameXLS = "{}_{}.xls".format(valueStatesAbbreviationsFS, valueCDCCode)
outXLS = os.path.join(footageReportFolder, footageReportFolderName, stateMapNameXLS)
exportLoc = "{}/{}/{}".format(footageReportFolder, footageReportFolderName, footageReportGDB)
stateMapName - "{}_{}".format(valueStatesAbbreviationsFS, valueCDCCode)
for field in arcpy.ListFields('Target Feature'):
if field.name == 'TotalFeet':
stats.append(['TotalFeet', "SUM"])
stateMap_stats_inmem = os.path.join("in_memory", "stateMap_stats_inmem")
try:
arcpy.Statistics_analysis('Target Feature', stateMap_stats_inmem, stats)
arcpy.TableToTable_conversion('Target Feature', exportLoc, stateMapName)
arcpy.TableToExcel_conversion(stateMap_stats_inmem, outXLS)
finally:
arcpy.Delete_management("in_memory")