EXCEL IF function using date

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns. 

 

The 3 columns are:

 

A. Date

B. Payment In/Out

C. Amount 

 

I want to summarise the data and add of the total payments in month by month. E.g. In October 2013 I need to know what is the total value of payments in. 

 

So I need a formula which essentially does something like this:

 

If column A is between 01/10/2013-30/10/2013 and if Column B says “IN” add up the values in Column C. 

 

Can you please help me. 

 

Much appreciated.

 

Kind Regards,

Daniel  

By: Daniel

Leave a Reply

Your email address will not be published. Required fields are marked *