You can make the adjustment in the formula..
Quote Originally Posted by gutkinma View Post
I have a sumproduct function that validates certain values and it is not working if values are values and not texts (=sumproduct(A1:A10,--(B1:B10=C1)), where C1 is ['123123].

Cheers!
=sumproduct(A1:A10,--(B1:B10&""=C1))
or
=sumproduct(A1:A10,--(B1:B10=C1+0))