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,


By: Daniel

Leave a Reply

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