+ 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,975
    Thank Post
    287
    Thanked 266 Times in 191 Posts
    Rep Power
    115

    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
    9,261
    Thank Post
    240
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    The file is corrupt...

  3. #3

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Yh file is corrupt (no files to extract)

    James.

  4. #4


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    Works fine for me, just can't do what he wants

  5. #5


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    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
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Gharr! now ur one is corrupt lol. whats going on

  7. #7


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    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
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    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
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    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
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Ignore me i never read it right

  11. #11
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,975
    Thank Post
    287
    Thanked 266 Times in 191 Posts
    Rep Power
    115
    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,975
    Thank Post
    287
    Thanked 266 Times in 191 Posts
    Rep Power
    115
    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,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    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
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    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,617
    Thank Post
    1,230
    Thanked 776 Times in 673 Posts
    Rep Power
    235
    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
  •