When comparing a criteria field to a cell in which the desired value exists, I get a "division by 0" error. However, when I enter the desired value directly in the criteria field, it works. I've tried with and without double quotes, but neither one works. ( This is in using the AVERAGEIFS function).