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...
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