Results 1 to 2 of 2

Running Total including Null values

Threaded View

Spolzie Running Total including Null... 12-12-2011, 06:03 PM
Ishtiyaq Re: Running Total including... 12-12-2011, 11:53 PM
  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Amarillo, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Running Total including Null values

    I need help with a simple formula:

    I have attached a spreadsheet example.

    Concept:

    Total Charge

    Three Savings Buckets A, B, C

    Bucket A Savings = Total Charge minus Bucket A Allowance

    Bucket B may be null with no activity so

    when I start with Bucket C, formula needs to start with the Bucket A Allowance

    All Buckets with values
    Charge A Allow A Save B Allow B Save C Allow C Save
    500 350 150 300 50 100 200
    500 - 350 350 - 300 300 - 100

    Bucket with Null Value

    Charge A Allow A Save B Allow B Save C Allow C Save
    500 350 150 Null Null 300 50
    500- 350 350 - 300

    Need formula sees null and takes last subtotal > 0 and Null = no entry at all not zero
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1