| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amount with two conditions
Please help me.
How to sum amount for special date & amount's nature (Debit/Credit), example (Column A) (Column B) (Column C) Amount Amount's Nature Date Row 1 1,500 D Feb 25, 2009 Row 2 300 C Dec 31, 2009 Row 3 150 D Feb 28, 2009 I want only February Balance (D-C=1500-150) in one cell or Debit Amount in a cell & Credit in diff' one. Which function I should use, the conditions are Date & Amount Nature Please help me. -- MFS22 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Amount if two conditions are met | Excel Worksheet Functions | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Threaded Mode
