#Invalid Data Type Help
I have this simple functions:
The formula works fine if in the range A1:D1 I have 1 cell containing "apple".
If 2 or more cells contain "apple" the formula now returns "Invalid Data Type" error.
The same formula in excel works fine, so not sure what I'm doing wrong?
Help Article Resources
Check out the Formula Handbook template!