Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Values Incrementally (2002)

    I want to be able to check off rows in a cash resources sheet and have them added up if checked. Not quite sure how to do this. I want the results to be in a cell.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Values Incrementally (2002)

    In the first place, Excel is not the ideal application if you really want check boxes. It is possible to put a check box in a lot of rows, but you have to do a lot of work. What happens if rows are added or deleted?

    If you can live with a column in which you enter (for instance) 1 for rows to be "checked", things are a bit easier.

    Do you want a sum for each row - to be calculated only if that row is checked? Or do you want one sum over all checked rows?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Values Incrementally (2002)

    I just want it to work. Good point on deleting rows had not thought of that. I just want a sum in one cell.
    Thnaks
    Frank

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Add Values Incrementally (2002)

    Agree with Hans. Rather than a checkbox, use a 1 to indicate checked, or a single letter, such as "Y", or "P" if it's for presented checks, or whatever suits. Then if the range of numbers is A1:A50 and the range of "check codes" is B1:B50 and the checkoff code is the letter "Y", in your single cell formula use:

    =SUMIF(B1:B50,"Y",A1:A50)

    HTH.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Values Incrementally (2002)

    Not quite what I'm trying to do.
    Let's say on row 1 I have cash available 5.00.
    On row 2 Bank funds available is 10.00
    and so forth.
    If I check row 1 or put a 1 that is the total say in Cell A!.
    If I also put a 1 in row 2 this is added to the vailue in A!

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Add Values Incrementally (2002)

    I'm confused about the data layout. Can you post a sample of your layout?
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Values Incrementally (2002)

    If I understand your description, that is exactly what John's formula does. If you have tried his formula and it does not do what you want, then could you post an example workbook to show us what you mean?
    Legare Coleman

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Values Incrementally (2002)

    See the attached workbook. Does that help?
    Attached Files Attached Files

  9. #9
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Values Incrementally (2002)

    Thanks all for your help things are working now.
    Frank
    sorry for the delary out of town

Posting Permissions

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