Sumif not working with Text

[MatthewLester]

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. It will not work until I change the selection criteria data to a number. 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!!

[#2]

@MatthewLester 

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

[#3]

Thanks - I think I have checked that

How do I submit a file?

@Sergei Baklan 

[#4]

@MatthewLester 

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

[#5]

Ah - thanks - I have found the problem. Hidden rows with matching negative entries - it was working but totalling zero. Arrgghhh! 

thanks for your help

@Sergei Baklan 

[#6]

@MatthewLester , so far so good, great to know it fixed