Hi,
I would like to average column B if column A is between a certain date range.
Column A Column B
Date Amount
01/01/2015 £10.00
01/01/2015 £20.00
02/01/2015 £30.00
02/01/2015 £40.00
02/01/2015 £50.00
03/01/2015 £100.00
04/01/2015 £70.00
05/01/2015 £10.00
06/01/2015 £20.00
07/01/2015 £40.00
08/01/2015 £100.00
Date Average amount
01/01/2015 - 07/01/2015 £39.00
08/01/2015 - 14/01/2015 £100.00
Thank you in advance.
Rachael
Bookmarks