What do you mean by that? Are you trying to sum textstrings?
If so you need to extract the numbers and then sum them, if there is a logic
to it like
abc123
where you always would have 3 letters followed by numbers then you can use
=SUMPRODUCT(--MID(A1:A20,4,255))
note that if there are blank cells or no numbers it will return an error
Regards,
Peo Sjoblom
"buyer1" wrote:
I can not get sumif to recognize cells containing alphanumberic data. I have
changed the data to text but that still does not work.
|