+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
How do you do....it? Thread, Excel Question / Formula Needed in Technical; As for actual problem, there are two possible solutions. You could enter the out figure with a minus then you ...
  1. #16

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17
    As for actual problem, there are two possible solutions. You could enter the out figure with a minus then you would just do a simple SUM to get to the running total.

    Alternatively, you could SUMIF so that the value in a particular column is only added to the running total if the word out appears in column B. As an example put the following in cell C4.

    Code:
    =SUMIF(B5:B1000,"=IN",C5:C1000)-SUMIF(B5:B1000,"=OUT",C5:C1000)
    Last edited by m2d2; 4th August 2008 at 07:04 PM.

  2. Thanks to m2d2 from:

    timbo343 (4th August 2008)

  3. #17
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,035
    Thank Post
    305
    Thanked 293 Times in 203 Posts
    Rep Power
    120
    Quote Originally Posted by dhicks View Post
    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

    THANKS!!!!!

  4. #18


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,693
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    Give that man a cookie, he makes it sound simple.

  5. #19

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17
    @dhicks
    I am sorry but using another column is cheating.

    I wanted to do the entire formula in one cell but I can't get MATCH() to return correct offset from A5 . I wanted to use this as upper bound of the range of each SUM().

  6. #20

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,656
    Thank Post
    1,262
    Thanked 783 Times in 680 Posts
    Rep Power
    236
    Quote Originally Posted by m2d2 View Post
    I am sorry but using another column is cheating
    Hmm! It's the sort of thing where you wish Excel's formula language was more capable and could do something like map(array, function).

    --
    David Hicks

  7. #21
    TechSupp's Avatar
    Join Date
    Mar 2007
    Location
    South Yorkshire
    Posts
    1,908
    Thank Post
    304
    Thanked 122 Times in 103 Posts
    Rep Power
    42
    Its not a solution to the excel problem just a comment that I have had this problem when downloading zip files etc from edugeek (other sites seem fine). Downloads OK but can't open it as it says it is corrupt?

  8. #22


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,693
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    Interesting.. What browser are you using?

  9. #23

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,068
    Thank Post
    160
    Thanked 925 Times in 727 Posts
    Blog Entries
    3
    Rep Power
    273
    Make a post in Site problems instead of us sorting it our here

    James.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

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
  •