question

Runner-2178 avatar image
0 Votes"
Runner-2178 asked emizhang-msft edited

running total by nearest group in Excel

124772-running-total-by-nearest-group.png



Hello
is it possible in excel create running total by nearest group like in image.
Thanks

office-excel-itprooffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft edited

Hi @Runner-2178,
Try this formula:

 =B2+IF(A2<>A1,0,C1)

124971-461.png


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




461.png (14.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.