Aug 21 2019 03:41 AM
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!!
Aug 21 2019 03:44 AM
Perhaps your criteria range is formatted as numbers. Could you submit small sample file?
Aug 21 2019 04:03 AM
Aug 21 2019 04:12 AM
Aug 21 2019 04:27 AM
Ah - thanks - I have found the problem. Hidden rows with matching negative entries - it was working but totalling zero. Arrgghhh!
thanks for your help
Aug 21 2019 05:00 AM
@MatthewLester , so far so good, great to know it fixed