I'm using the mileage log., How do I total all the mileage?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ricaislandgirl - 02 Apr 2007 23:14 GMT

This is the first time that I'm using the Mileage Log, How do I get the total>

Reply to this Message

Gord Dibben - 02 Apr 2007 23:30 GMT

Insert a row at bottom of existing log sheet below row 34.

In Mileage column J35 enter =SUM(J7:J34)

Gord Dibben MS Excel MVP

>This is the first time that I'm using the Mileage Log, How do I get the total>

Reply to this Message

Gord Dibben - 02 Apr 2007 23:35 GMT

Or look in E4 for the formula =SUM(J7:J34)

If you are using the mileage log found here.

http://office.microsoft.com/en-us/templates/TC060884581033.aspx?pid=CT1014409910
33&AxInstalled=1&c=0

Gord

>Insert a row at bottom of existing log sheet below row 34.
>
[quoted text clipped - 3 lines]
>
>>This is the first time that I'm using the Mileage Log, How do I get the total>

Reply to this Message

Rate this thread: