I am looking for a phrase

G

Gideon

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cycle through all the available Fonts 2
VBA for data validation in 3rd column does not run. I need help. 1
DSUM I think 1
Thumbnail vs open photo 2
Spliting rather mixed up address 7
I need to look for a number and return the column heading. 6
How do I average every 3rd cell in a column of a spreadsheet? 3
XL 2003: How do I get every possible combination? 14

Top