Hi
I need to average the values in column C if the value in column A is "Apples" and the date in column B (e.g 7/14/12) is in July 2012. I need to do this for all months in different years.
I've tried =AVERAGEIF but I'm getting nowhere.
Thank you