Sum group total in report footer

I have a rather odd report.  I use queries to collect the data I need into a make table.  The report shows multiple stores within multiple counties.  One of the criteria that I append repeats for all the stores (which I don't want).  So on the report County grouping I show the field but I don't Sum by that field.  It shows the amout once.  And that works.  The problem is that I want to sum that county field in the report total.  The field that shows the correct data is called txtTarget.  If I put =Sum([txtTarget]) in the Report footer it asks for txtTarget parameter.  If I just Sum the field name (Target) it multiplies the single amount I want by all the stores in that County.  Is there any simple way around this?  

Report Ex:
County 1    Amt        Target
   Store 1    $35          $53 (shows in make table but not on rpt- which is what I want)
   Store 2    $25          $53 (shows in make table but not on rpt- which is what I want)
   Total        $55          $53 (shows on report because I don't sum the field- which is what I want)

County 2
   Store 1    $20          $51 (shows in make table but not on rpt- which is what I want)
   Store 2    $30          $51 (shows in make table but not on rpt- which is what I want)
   Total        $50          $51 (shows on report because I don't sum the field- which is what I want)

Rpt Total     $105       $104 (what I want but I get parameter error or $312)