Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cumulative Formula (2000/XP)

    Can someone help me with this formula? The user does not want the cumulative to appear all the way down the column. This is the formula she is using. =+$F16+$G15 it is just copied down to the rest of the cells. Most of the time the cumulative only has a few rows filled out.
    Transaction Cumulative
    Amount Amount
    50.00 50.00
    34.00 84.00
    56.00 140.00
    140.00
    140.00
    140.00

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

    Re: Cumulative Formula (2000/XP)

    Try:

    <pre>=IF($F16<>"",$F16+$G15,"")
    </pre>

    Legare Coleman

Posting Permissions

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