#Invalid Data Type Help

Hi All,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!