Thread: I am looking for a phrase
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default I am looking for a phrase
Try

=COUNTIF(A1:A100,"*PETRO*")

Mike

"Gideon" wrote:

I am using a simple command countif and sumif but my criteria is differant
each time although I want to use that line to count or sum the awnser like
-100 PETRO S#BP SUNNYROCK 8790520001361546
-380.04 PETRO S*CARNIVAL CITY S/ST8790520001361546
-129.67 PETRO S*KRAFT RD BP 8790520001389844

I want to use the phrase perto "and not the whole line as they differ each
entry"to calculate the values in another cell

Please help I know there must be a special caracter to look only for the
phrase perto in a sentance.

Thanks

Reply With QuoteReply With Quote