Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Summing By Day (2000)

    I am in the energy business and I purchase fuel on a daily basis for delivery throughout a given month. For example, I might purchase 3100 gallons of No. 2 fuel oil sometime in December and have it scheduled for delivery in 100 gallon increments on each day throughout the month of January. In addition, I might also purchase 300 gallons on the 10th of January to be delivered on the 11th, 12th and 13th (again, in 100 increments; in addition, I might also have this 300 gallons delivered all in one day, say, on the 12th). Finally, I might also purchase, say, 1600 gallons on the 12th to be delivered in 100 gallon increments on the 16th-31st. What I would like to do is summarize on a daily basis the total deliveries on each day. I currently have my spreadsheet set up as follows: column A-name of Seller, column B-total gallons purchased, column C-date purchased, column D-beginning delivery date, column E-ending delivery date. I know there is an easy answer-I am just baffled as to what it is! Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Summing By Day (2000)

    Does the attached workbook do what you want? It uses array formulas to calculate the deliveries for each day, assuming that the deliveries of a single purchase are *always* distributed evenly (the same amount every day from beginning to ending date).
    Attached Files Attached Files

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Summing By Day (2000)

    Pivot table
    SUMIF formulas
    Array formulas
    Data Tables

    Should all give you want you want, depending on all the requirements. Example? Details?

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Summing By Day (2000)

    Hans,
    Looks like you did the trick!
    I will test it on my data and let you know.
    Thanks,
    Jeff

Posting Permissions

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