Results 1 to 5 of 5

sum a range until the cell to the left is zero

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    Crossville, TN
    MS-Off Ver
    Excel 2010
    Posts
    2

    sum a range until the cell to the left is zero

    I want to get the years old column/cells
    that would look to the left and calculate
    the numbers of years an account is…

    For example above, row 2 - should return
    a 3, as the account is 3 years old

    Row 3 needs to be a 1….
    meaning stop counting going to the left
    once a cell that is "0" is reached.
    See attached file
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deselect all cells in range except top left cell
    By pkew22 in forum Excel General
    Replies: 2
    Last Post: 07-23-2013, 03:44 PM
  2. Mix of non-empty cell range search & left vlookup
    By wouZa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 02:47 PM
  3. [SOLVED] Unselect Range to top left cell
    By pkew22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2013, 01:49 PM
  4. Content of cell in upper left corner in a range
    By mkvassh in forum Excel General
    Replies: 4
    Last Post: 10-07-2011, 03:15 AM
  5. Replies: 2
    Last Post: 06-29-2006, 02:00 AM

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