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

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
>

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
>