Hello Excel experts,
I would like to ask you for some help. I have an Excel 2007 table with two columns: month and amount. I want to get the average of the amount excluding the current month. I am using =AVERAGEIFS(MyTable[Amount], MyTable[Month], "<>"&B1), where B1 = "April 2010". However, the calculation seems to get the average wrong, as it counts the amount corresponding to April 2010. Would someone please help? I am attaching an example sheet.
Bookmarks