SUM PRODUCT & CUMMULATIVE BALANCE
 

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

SUM PRODUCT & CUMMULATIVE BALANCE
 

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

SUM PRODUCT & CUMMULATIVE BALANCE
 

Bernard,

Following is my data. I am able to sum transaction for each particular date. So, in my summary sheet, which is Sheet 1, I would like to see under:

August 31st, a balance of $46,091,530.12
September 1st, a runninng balance of $46,092,030.54 and so on an so forth
:
GL FOLIO DATE DESCRIPTION AMOUNT CUMMULATIVE
320 0 31-Aug-06 46,091,530.12 46,091,530.12
320 84380 1-Sep-06 ISSUES MATERIAL WORK IN PROCESS 500.42 46,092,030.54
320 84399 2-Sep-06 ISSUES MATERIAL WORK IN PROCESS 471.38 46,092,501.92
320 84547 3-Sep-06 ISSUES MATERIAL WORK IN PROCESS 67.41 46,092,569.33
320 84555 4-Sep-06 ISSUES MATERIAL WORK IN PROCESS 34.50 46,092,603.83
320 84573 5-Sep-06 ISSUES MATERIAL WORK IN PROCESS 14.34 46,092,618.17


Thanks
SJ
"Bernard Liengme" wrote in message ...
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

SUM PRODUCT & CUMMULATIVE BALANCE
 

Since the dates on Sheet1 are in the same order as needed in the Cumulative why not
=Sheet1!C2 to get the date and =Sheet1!F2 to get the cumulative

OR use VLOOKUP
On the Cumulative page you have dates in A (starting in A2, say)
Sheet1 has data in A2:F500
So on Cumulative use =VLOOKUP(A2,Sheet!$A$2:$F$500,6,FALSE) and copy down

I do hope I understand the problem.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SSJ" wrote in message ...
Bernard,

Following is my data. I am able to sum transaction for each particular date. So, in my summary sheet, which is Sheet 1, I would like to see under:

August 31st, a balance of $46,091,530.12
September 1st, a runninng balance of $46,092,030.54 and so on an so forth
:
GL FOLIO DATE DESCRIPTION AMOUNT CUMMULATIVE
320 0 31-Aug-06 46,091,530.12 46,091,530.12
320 84380 1-Sep-06 ISSUES MATERIAL WORK IN PROCESS 500.42 46,092,030.54
320 84399 2-Sep-06 ISSUES MATERIAL WORK IN PROCESS 471.38 46,092,501.92
320 84547 3-Sep-06 ISSUES MATERIAL WORK IN PROCESS 67.41 46,092,569.33
320 84555 4-Sep-06 ISSUES MATERIAL WORK IN PROCESS 34.50 46,092,603.83
320 84573 5-Sep-06 ISSUES MATERIAL WORK IN PROCESS 14.34 46,092,618.17


Thanks
SJ
"Bernard Liengme" wrote in message ...
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