View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy Landry
 
Posts: n/a
Default Mileage Calculation

Hello,

I need to calculate the current IRS mileage rate and then have a combined
total by fac# example:

11/01 10 miles to be charged to fac# 111
11/02 10 miles to be charged to fac# 222
11/03 10 miles to be charged to fac# 111
11/04 10 miles to be charged to fac# 222

The form we are currently using does calculate the mileage rate for each
line but does not combine all the mileage on different dates to the same fac.
Ideally, the total column would only show 111 & 222 once.

Possible?

Thank you
Cathy