Forum Discussion
Average Ifs with multiple criteria
Hey gus! I am trying to find the average cost for each category under specific criteria. Inf_Sales_Data!B:B is the month and this should match the current month on the sheet. Inf_Sales_Data!A...
I have taken over the creation of a sample file. At least as I have understood it.
The mean value is calculated with AVERAGEIFS. This function has been available since Excel 2007, so it should be suitable for everyone. It is also available in Google Sheets with the same syntax.