Excel

Hi,

I am editing a spreadsheet that lists in rows a number of transactions between 2004-present. Each transaction runs for a number of days (number of days varies in each transaction) and generates an income. One of the columns lists the average daily income for each transaction (income of transaction divided by number of days of that specific transaction).

I am trying to figure out a way of getting the average daily income for each year, which will change on a rolling basis (i.e. each time a transaction is added the average daily income for that year will be affected).

I have tried using a conditional formula to select the transactions of a given year (something like COUNTIF 2012, or COUNTIF 2013) by eliminating the transactions of other years and then calculate the sum of all average daily incomes and divide by the number of days that have elapsed since January 1st.

I am confused and although I suspect that a conditional formula is the way to go, I'm not sure about it.

Your help will be greatly appreciated.

Best,
M