View Single Post
  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.