+ Reply to Thread
Results 1 to 4 of 4

I need to create a spreadsheet that will calculate total money spent and total savings

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Melbourne, Victoria
    MS-Off Ver
    Excel 2003
    Posts
    2

    Red face I need to create a spreadsheet that will calculate total money spent and total savings

    Hi!
    I need to set up an easy to use spread sheet for my office. It needs to be able to calculate the running total spent of fuel, as well as include any discounts we get and then calculate our total savings.
    So basically, total spent and total saved.

    I really hope some one can help, I feel like the answer is very simple I just cant reach it!

    Thanks
    Alicia

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: I need to create a spreadsheet that will calculate total money spent and total savings

    So the fields would be date,gallons,total spent, discount ?

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    Melbourne, Victoria
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: I need to create a spreadsheet that will calculate total money spent and total savings

    Im just entering the receipts so it would be Date, amount paid, discount, total cost, total savings.

    Thanks

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: I need to create a spreadsheet that will calculate total money spent and total savings

    Something like the attached.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate money Spent between two dates??!!!
    By Copperspaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 05:53 PM
  2. Calculate varying % of Total depending on total sum.
    By mwest316 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-02-2013, 01:59 PM
  3. Replies: 1
    Last Post: 10-27-2011, 11:43 AM
  4. total time spent for a specific employee
    By haylnut in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-14-2007, 02:38 AM
  5. [SOLVED] excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?)
    By Harris in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2006, 04:35 PM

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