I have a custom UDF (user defined function) that I have been using for about 2 years with success. I am now trying to use it in an array formula and getting a #Value! error.
The UDF looks like this...
=MyUDF(A1,B1)
...where A1 is a string to be evaluated and B1 is a number. Basically, the function returns another number depending on the relationship of the two inputs. I have not had any issues in the past using it as shown above.
Now, I would like to use this function on a range of cells and sum the results. Here is what I have now...
{=SUM(MyUDF(A1,B1:B100))}
Does anyone know why this returns a #Value! error?
The UDF looks like this...
=MyUDF(A1,B1)
...where A1 is a string to be evaluated and B1 is a number. Basically, the function returns another number depending on the relationship of the two inputs. I have not had any issues in the past using it as shown above.
Now, I would like to use this function on a range of cells and sum the results. Here is what I have now...
{=SUM(MyUDF(A1,B1:B100))}
Does anyone know why this returns a #Value! error?