+ Reply to Thread
Results 1 to 2 of 2

Subtotal Function Problem

  1. #1
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Subtotal Function Problem

    diesel fuel subtotal example.xlsx
    please see the attached file.
    I have performed three separate subtotals, at each change in vehicle, the first subtotal is for the the quantity, easy enough.
    I then added two columns next to odometer, labeled odo1 and 2.
    I then subtotaled odo 1 for a min function and odo 2 for a max. My plan was to then compute miles driven in the miles column by subtracting min from max odometer readings.
    I would like to automate the subtraction of odo 1 from odo 2 to get total miles driven for that truck that month.
    The number of rows vary each month, at first we thought of subtracting the last line from the first but that did not work as we couldn't figure out how to handle the varying number of lines for each vehicle and came up with this method instead.
    Is there another way of doing this?
    The actual sheet is 5562 lines long with varying numbers of lines for each vehicle each month.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Subtotal Function Problem

    Hi MARKSTRO
    Have a look at this example to get you started with the layout

    Excel Forum Fills.xls
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1