Cumulative Total

[Anurodh123]

Hi Experts,

I needed to calculate cumulative total balance of loan amount for a customer who has booked various trades on different dates.

End result I needed is in column F but I needed one single formula to calculate cumulative total for the loans booked on the same date and gradually decreasing with each settlement.

Thank you for your help.

Cumulative total - help.JPG

[Fluff13]

How about
=IF(COUNTIF(C$5:C5,C5)=1,SUMIF(C$5:C$12,C5,E$5:E$12),F4-E5)
in F5 copied down

[Anurodh123]

Awesome!! Thanks Fluff13

[Fluff13]

Glad to help & thanks for the feedback