ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   I'm using the mileage log., How do I total all the mileage? (https://www.excelbanter.com/new-users-excel/137572-im-using-mileage-log-how-do-i-total-all-mileage.html)

ricaislandgirl

I'm using the mileage log., How do I total all the mileage?
 
This is the first time that I'm using the Mileage Log, How do I get the total

Gord Dibben

I'm using the mileage log., How do I total all the mileage?
 
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

On Mon, 2 Apr 2007 15:14:09 -0700, ricaislandgirl
wrote:

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



Gord Dibben

I'm using the mileage log., How do I total all the mileage?
 
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/te...talled =1&c=0


Gord

On Mon, 02 Apr 2007 15:30:46 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Mon, 2 Apr 2007 15:14:09 -0700, ricaislandgirl
wrote:

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




All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com