Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count how many times a phrase comes up? | Excel Worksheet Functions | |||
Convert a number to phrase | Excel Discussion (Misc queries) | |||
Delete a row with a certain phrase? | Excel Programming | |||
Delete a row with a certain phrase? | Excel Discussion (Misc queries) |