Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMIF and change in a cell (Excel 2000)

    Hello Everyone,

    I have a column of values that may change, at the bottom of the column "TOTAL:".
    I only want to add the values that have changed, is this possible?
    I was thinking of using the SUMIF formula.

    Thanks Kindly,

    Kerrie [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF and change in a cell (Excel 2000)

    You would need to tell Excel which cells are changed.
    What event should reset the changed cells?

    I would add a column next to the cells to be changed and let a macro put a 1 next to the cells you've changed. Use SUMIF to test for the 1's and sum the cells next to them:
    =SUMIF(C1:C100,1,A1:A100)

    Then use an event macro that removes all 1's when the workbook is opened (maybe with an are-you-sure message).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    London, Gtr London, England
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF and change in a cell (Excel 2000)

    An extension to the suggestion from Pieterse would be for the macro to store the the time and date of the change in the column by capturing the Now() value in the coulmn, this would allow you to total the changes made over particular period, and would not require the event macro on opening the file.

Posting Permissions

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