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
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
IN this context, what is cumulative balance?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
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