S
SSJ
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
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