User Tag List

Results 1 to 5 of 5
  1. #1
    CaToonie
    Join Date
    May 2011
    Location
    Tamworth, Ontario
    Posts
    294
    Likes Received
    0
    Trading Score
    -1 (0%)



    0
    I'm trying to make up a simple spreadsheet on Microsoft Excel Starter for my weekly shopping trips. Right now I have a column for the item, the price, coupon and the total.

    What I want to do is have the coupon column subtract from the price column, have those two total and then have a final total at the bottom of the page. I know it's very simple, but I can't figure out how to do it.

    Any guru's out there?
    This thread is currently associated with: Microsoft


  2. #2
    Smart Canuck ame555's Avatar
    Join Date
    Sep 2008
    Location
    Ottawa
    Posts
    1,616
    Likes Received
    28
    Trading Score
    65 (100%)



    There is probably a template online - but you will need to add up the column with the coupons and the minus it from the shopping total -- do you know what version you are using?

  3. #3
    CaToonie
    Join Date
    May 2011
    Location
    Tamworth, Ontario
    Posts
    294
    Likes Received
    0
    Trading Score
    -1 (0%)



    That's exactly what I want to do, but I can't figure out how to enter the formula's.

    I'm using Starter 2010

  4. #4
    Moderator
    Join Date
    May 2010
    Location
    Hamilton, ON
    Age
    46
    Posts
    23,423
    Likes Received
    14245
    Trading Score
    254 (100%)




    This is the formula for sum =SUM(A2:A4) plug this in and change the cell numbers to whatever you want. You can drag the formula down the column to add up subsequent rows.

    For the difference between to columns the formula is =A2-A3

    HUH? YOU DON'T DO SWAGBUCKS??? ARE YOU CRAZAY?!
    SIGN UP!!! SIGN UP!!!


  5. #5
    Mastermind Natalka's Avatar
    Join Date
    Oct 2008
    Location
    SK
    Posts
    118,045
    Likes Received
    147799
    Trading Score
    29 (100%)




    I don't do it myself, but an SC member posted some excel savings charts - check here on post 112

    http://forum.smartcanucks.ca/90767-d...ator-canada-8/

Thread Information

Users Browsing this Thread

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

Posting Permissions

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