Mileage Reimbursement form: Trying to show the sum of reimbursement based on destination

Using Excel 2010, I created a mileage reimbursement form. I need to allocate the sum of the individual daily mileage reimbursements by destination for my own record keeping purposes.

Column C20:C38 are the Destinations. The destinations are noted in dropdown selections.
Column F20:F38 are the daily mileage Reimbursements.

I would like to see the sum of each daily reimbursement by destination in Column F6:F18 . The destinations noted in Column E6:E16 coincides with all the Destination dropdown selections that are noted in Column C20:C38.

Thanks so much for your assistance!Mileage Reimbursement Form blank 2.12.15 test.xlsx

You say daily but you have multiple dates in your data, so do you want the sum for each destination for the dates that fall between your pay period start and end dates in G4 and G5?

Originally Posted by jbrottman

Sorry for the confusion. I am seeking the sum for each destination based on all the dates noted on the sheet.
So for example:
The sum for Garden City in Column F7 should be $27.44 (Cell F20 + Cell F22).

Sorry for the delay I got sidetracked.
Put this formula in E6 and then you can copy it down.

=SUMIF($C$20:$C$39,$D6,$F$20:$F$39)

Good Luck!

WOW! Thank you so much!

My pleasure.