Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product Selection order form | Excel Worksheet Functions | |||
I have two columns (A) and (G) that have like product codes however | Excel Worksheet Functions | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |