I am looking for a phrase
 

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

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

I am looking for a phrase
 

If you mean the sum of all entries which has got a PETRO. Assuming your data
in ColA and B try the below

=SUMIF(B1:B100,"*petro*",A1:A100)

If this post helps click Yes
---------------
Jacob Skaria


"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