Forum Discussion
Solved
SUM.IF
Hi team, I'm using sum.if formula on two different tables. The criteria to sum up amounts is the list of numbers here below. 5806524220010000003340946 5806524220010000016288417 58065242200100000...
Thanks for your prompt reply.
Unfortunately leading numbers are not always the same.
Nevertheless in the REMARKS in https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
is said that "The SUMIF function returns incorrect results when you use it to match strings longer than 255 characters or to the string #VALUE!."
So I thought that the problem was not lenght of the criteira string.
Thanks a lot
rinaldo
rc14354 , you have no one error on your screenshot. And what do you exactly do, you convert texts in first column to values and sum them based on criteria, or you use them as criteria?
I do not convert first column in text but I use them directly as criteria