Need it to sum total miles for week on seperate sheet

[MsMel]

I have a work sheet for the week that tracks miles for employees. On a seperate worksheet I need it to calculate the total miles for that week for each employee.

[ChemistB]

Okay, the only numbers I see in your example is Job # and DT (Down time?). Where would we be pulling the miles from?

More questions:
Will a driver have multiple jobs on a single day? IF so, how would that look? Would these multiple jobs be listed in congruent rows or would other drivers fall in-between them?

[JohnTopley]

What do the "arrows" imply? If they are a substitute for numbers then put in the numbers.

I would think very carefully about how you have organised your data: very "pretty" but not very practical not least having a sheet per week as suggested by your sample.

Think how you might summarise a month (or longer).

[MsMel]

Sorry I haven't changed it yet. But the DT is the miles. We recently switched from Drive time to miles.

[MsMel]

So the arrows imply that it is the same job number and information from the AM.

[MsMel]

Okay, the only numbers I see in your example is Job # and DT (Down time?). Where would we be pulling the miles from?

More questions:
Will a driver have multiple jobs on a single day? IF so, how would that look? Would these multiple jobs be listed in congruent rows or would other drivers fall in-between them?

I updated the spreadsheet. Bravo is how I start my week. Blank
Charlie is he is at the same job for the day and would get paid for 80 miles.
Frank on Tuesday Switched jobs but because I calculate the mileage I enter a total for him vs two separate numbers for each job.