So I have a workbook with multiple sheets and I need to average data based on the month and year in the adjacent cell. I have an array that I plug in to do monthly averaging, but I'm trying to go back and get older data. My date column (A) is setup month/day/year. The data that I want to average is in column (C). Also I need to keep the empty cells out of the formula.
Bookmarks