Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mod Formula for Mileage? Debbie D. Excel Worksheet Functions 3 March 19th 07 06:38 PM
mileage john14310 Excel Worksheet Functions 2 June 8th 06 01:16 AM
Gas Mileage Lacreeda Excel Discussion (Misc queries) 5 May 14th 06 03:49 AM
Gas Mileage Patsy Excel Worksheet Functions 4 May 11th 06 05:57 PM
chart: mileage MPG Fuel total paid Nightowl Charts and Charting in Excel 0 March 11th 06 07:06 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"