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:
B. Payment In/Out
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.