I figured out the problem. I have hidden rows that are being used in the calculation. I understand that the averageif function will use only the visible rows. I've looked at several sites trying to understand how to set up the three arguments to use averageif, but I'm not quite getting it.