2.1.931 Part 1 Section 18.17.7.89, DEVSQ
a. The standard does not specify the return value when the argument is an array or a reference that contains only text, logical values, or empty cells.
-
Office returns #NUM! when argument is an array or a reference that contains only text, logical values, or empty cells.