Sumif not working with Text

Question

I can't get sumif to work with text (I normally can). I have tried cell reference and "text" in the selection criteria in the formula.&nbsp;It will not work until I change the selection criteria data to a number.&nbsp;When I create new text data, it works fine, when I use the data I need to SUM (supplied by someone else) it does not work. Help!!

sergeibaklan · Answer

MatthewLester&nbsp;
Perhaps your criteria range is formatted as numbers. Could you submit small sample file?

matthewlester · Answer

Thanks - I think I have checked thatHow do I submit a file?&nbsp;SergeiBaklan&nbsp;

sergeibaklan · Answer

MatthewLester&nbsp;
Click on this item at the bottom left of Reply window and select the file to attach.

matthewlester · Answer

Ah - thanks - I have found the problem. Hidden rows with matching negative entries - it was working but totalling zero. Arrgghhh!&nbsp;&nbsp;thanks for your help&nbsp;SergeiBaklan&nbsp;

sergeibaklan · Answer

MatthewLester&nbsp;, so far so good, great to know it fixed

Forum Discussion

Sumif not working with Text

5 Replies

Resources