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