+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
How do you do....it? Thread, Excel Question / Formula Needed in Technical; Hi All Im after a massive favour. I need to create a spreadsheet with a running total but only to ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,772
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87

    Excel Question / Formula Needed

    Hi All

    Im after a massive favour. I need to create a spreadsheet with a running total but only to today's date. Please see the attachment. All the instructions are in there.

    Thanks

    Tim
    Attached Files Attached Files

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    The file is corrupt...

  3. #3

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Yh file is corrupt (no files to extract)

    James.

  4. #4


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Works fine for me, just can't do what he wants

  5. #5


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Have uploaded it again to see if you guys can open mine.
    Attached Files Attached Files

  6. #6

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Gharr! now ur one is corrupt lol. whats going on

  7. #7


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Weird ...

    Only thing different between us is that I'm on linux.


    EDIT: Try just renaming this one to xls from .zip.
    Attached Files Attached Files

  8. #8

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Nope dont work.. it dont want me to help you lol sorry :P

  9. #9

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Yay! works now.. Stoopid IE 8

    I am uninstalling that peice of crap right now! only lasted 3hrs and amount of problems unbelivable bloody M$

    Works with FF

    James.

  10. #10

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Ignore me i never read it right

  11. #11
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,772
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87
    lol, seems like you guys are having trouble even before you have a look at the problem. I can see it been a very complex formula

    Thanks

  12. #12
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,772
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87
    Updated: File Attachment

    Hopefully this one isnt corrupt!

    EDIT: I cant upload a stable version. They are all corrupt when they are uploaded.

    Ok I have uploaded a screen shot, hope it makes it a bit more clear

    Thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by timbo343; 4th August 2008 at 06:23 PM.

  13. #13


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    I don't know what's up because it works fine for me

    Screenie attached.
    Attached Images Attached Images

  14. #14

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    for all you windows users, i think there is an issue with IE

    If you use FF it works sound well did for me anyhow.

    James.

  15. #15

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,498
    Thank Post
    1,184
    Thanked 745 Times in 647 Posts
    Rep Power
    228
    Quote Originally Posted by timbo343 View Post
    I need to create a spreadsheet with a running total but only to today's date.
    You can do this with an IF formula in the columns to the right of the numbers you're typing in. If the given date is less than or equal to the current date (given by NOW()) then result is the value in the cell (or the negative of it, if you're looking at the "out" value), otherwise 0. I.e in F9 put:

    =IF(A9<NOW(),C9,0)

    And if F10 put:

    =IF(A10<NOW(),-C10,0)

    Make sure you start off with the correct total - in F6 put:

    =C6

    And in C4, calculate your total:

    =SUM(F6:F52)

    Adjust the formula for columns G and H. Hide them afterwards if you want.

    --
    David Hicks

  16. 2 Thanks to dhicks:

    kmount (4th August 2008), timbo343 (4th August 2008)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. office for mac excel formula question.
    By russdev in forum Office Software
    Replies: 2
    Last Post: 9th May 2008, 11:51 AM
  3. Excel VBA Loop Question
    By vunsev in forum Coding
    Replies: 5
    Last Post: 11th April 2008, 08:08 AM
  4. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  5. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM

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
  •