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

1. ## 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

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

Originally Posted by Rick Rothstein
Yes !
Thanks for looking into it.

4. ## 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:
`Please Login or Register  to view this content.`

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

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

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