Help Creating Mileage Calculation Formula with Blank Cells/Multiple Lines?

[BHN53168]

Hello,

I am trying to create a formula that will calculate mielage totals for our drivers' daily trips. I have attached a spreadsheet for your review. The fields I need totals in are highlighted in yellow.

I ultimately need total miles for each job (line), total WI miles for that day, total IL miles for that day, and total miles for that truck (tab). This is easily doable if our drivers sequentially fill in the cells and leave no blanks, however, that is rarely the case as they go to muliple jobs in multiple states. I have set up two examples, one in green and one in blue.

We need to tack all of this info for job costing and government purposes. Thank you for any help you can provide. We are on 2003.

[canapone]

Hi,

not sure about the results: most of the formulas are array and are to be confirmed with control+shift+enter.

You can adjust the MIN/MAX under conditions in several ways.

I hope it's a little help for your job.

Regars