SUM PRODUCT & CUMMULATIVE BALANCE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Cell reference being changed to a specific criteria in IF formula...HELP! 0
Multiple conditions 3
Need Help with a VBA subroutine 0
Running Balance (Debit and Credit) in Access 2007 3
Help with cummulative totals 3
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top