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