Hello!

I am able to use SUMPRODUCT to sum amounts based on dates as shown below:

=SUMPRODUCT((sheet2!$C$2:$C$1000=C1)*(sheet2!$E$2: $E$1000))

Column C have the dates and Column E have the amounts

How can I do cummulative balance using the SUMPRODUCT?

Thanks
SJ