Results 1 to 2 of 2
  • Thread Tools
  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. 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
  •