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
Bookmarks