I have the below SUMIF formula that works in my spreadsheet that I would like to modify to AVERAGEIFS based on all of the same criteria minus the column to Average.
I tried to sub out SUMIFS with AVERAGEIFS but all I get is a #DIV/0! error. Not sure why I am getting the error. I have also tried...