Amount with two conditions

M

MFS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add date condition 2
Vlookup? 1
Running Balance (Debit and Credit) in Access 2007 3
Macro Help 1
to lookup data for 'today()' 2
days calculation between dates 10
Nested IF 2
Help with lots of formulas 3

Top