ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Amount with two conditions (https://www.excelbanter.com/excel-worksheet-functions/223653-amount-two-conditions.html)

MFS

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


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com