Post an example of your data and your formula and let us know exactly what
you are expecting the formula to achieve.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"buyer1" wrote in message
...
I can not get sumif to recognize cells containing alphanumberic data. I
have
changed the data to text but that still does not work.