| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calulate amount based on multi condition
Hi,
I have a table similar as below, how can I calculate the amount of A during December 1 to 7? I know I can use DSUM for sigle result, but my purpose is to consoladate a table for A, B, C. Is there any formula I can use? coloum A coloum B coloum C 1/12/09 A 100 5/12/09 C 50 9/12/09 A 120 8/12/09 B 80 4/12/09 A 90 Thanks a lot! -- Lowan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
| Rank by Multi Condition | Excel Discussion (Misc queries) | |||
| Help with Multi-Condition Formula | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Multi-condition vlookup | Excel Worksheet Functions | |||
Threaded Mode
