+ Reply to Thread
Results 1 to 5 of 5

Find cumulative totals in column B between two NA values given in column A.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    221

    Find cumulative totals in column B between two NA values given in column A.

    Dear friends,

    I am stuck at a calculation which i thought would be very simple but it looks difficult than it appears. I am trying to find cumulative totals in column B between two NA values given in column A. I am looking for one single simple or array formula in B1 which after dragging can show the desired result. I have tried a lot but could not achieve. Request someone to help me with this.

    I am showing a pic below and also attaching a file. After dragging the formula in B1 downwards, it should show the results mentioned in cells highlighted in yellow.

    cumulative.png
    Attached Files Attached Files
    Last edited by sabha; 05-30-2021 at 12:24 PM. Reason: solved

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    1,996

    Re: Find cumulative totals in column B between two NA values given in column A.

    Will your data always start with NA in cell A1?

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    221

    Re: Find cumulative totals in column B between two NA values given in column A.

    Quote Originally Posted by Rick Rothstein View Post
    Will your data always start with NA in cell A1?
    Yes !
    Thanks for looking into it.

  4. #4
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    1,996

    Re: Find cumulative totals in column B between two NA values given in column A.

    Put this formula in cell B2 and copy down to the end of your data...
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    221

    Re: Find cumulative totals in column B between two NA values given in column A.

    Quote Originally Posted by Rick Rothstein View Post
    Put this formula in cell B2 and copy down to the end of your data...
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    It worked ! Thank you so much ! God bless !!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-10-2019, 04:36 PM
  2. Cumulative Sum and Find the target column?
    By ultrax in forum Excel General
    Replies: 1
    Last Post: 08-27-2018, 06:09 AM
  3. Replies: 3
    Last Post: 01-03-2014, 08:03 PM
  4. Replies: 2
    Last Post: 12-30-2013, 08:15 AM
  5. Take cumulative column down to instantaneous values
    By zax11029 in forum Excel General
    Replies: 2
    Last Post: 07-14-2010, 11:14 AM
  6. Replies: 3
    Last Post: 08-01-2006, 08:15 PM
  7. List cumulative values in a column
    By danie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 12:40 AM

Tags for this Thread

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