I want to do running total of BRASS (cumulative) of each MM month wise in google sheet. every month MM should start running total from beginning but should not add previous month. I have a formula that I pasted in G3. and I m getting running total but adding previous month.
CodePudding user response:
Try
=arrayformula(mmult((transpose(MONTH(B3:B))=MONTH(B3:B))*(transpose(row(D3:D))<=row(D3:D)),1*D3:D))