Hi all,
I have a set of data in column A which are dates.
I have a set of data in column B which are numbers
I want a forumula that will automatically average the months data dependant on what the current month is.
I've been playing with array functions:
=if(dates=month(today()),average(dataset),"")
Think i'm going about it completely wrong!
Can anyone help?
Thanks in advance :D
Bookmarks