minecraft how to grow sugar cane Therefore, the above formula refers to cells made up of numbers and text strings and adds the values to return the #VALUE! error. The error is since the expression performs an arithmetic operation that works only with numbers. But some input values, in this case, are text strings. // Obtain the collection o