Forum Discussion
Named items are now evaluating to #VALUE! errors in Function Arguments menu
I noticed an interesting quirk between the various 365 channels this afternoon. I understand AFE doesn't always sync with name manager so I tried re-loading AFE to confirm the presence of the named ...
I think it is only with LET local variables that I have seen these missing parameters. I wasn't clear, did 'colors' show in the ordinary Name Manager?
Yes. After more testing it seems this quirk is affecting functions which only accept ranges like COUNTIF, SUMIF, AVERAGEIF, etc. Array-friendly functions are not affected.