Any takers for an AverageIfs need. No Pivot Tables! No VBA! Formula only! https://www.excelforum.com/excel-for...statement.html