My machine runs Excel 2016 (Version 1701, Build 7766.2099 in case you're interested), and as you're aware Excel 2013 and 2016 added new functions (MAXIFS, MINIFS, etc.). Occasionally when I open a workbook which uses these functions, it shows #NAME when evaluating any cells relying on these newly added excel functions. I simply need to close and re-open the same workbook on the same machine, often in the same Excel instance for it to recognize these functions and behave as expected, but this feels very buggy (on a workbook I will need to distribute across my organization). Has anyone else observed this behavior, and if so have you been able to explain, predict, or address this issue?
H Jordan High
Decision and Economic Analysis Advisor