IN this context, what is cumulative balance?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SSJ" wrote in message ...
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