| 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 |
| 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 | |||
Threaded Mode
