can we count words in a row which has links from other file
 

The data in workbook A is updated using formulas using the data in workbook
B. Can we count the specific words/letters in the row where the data is
imported in workbook A.

Example: Cells E 6- H6 in work book 'A' contains a formula which imports the
data from workbook 'B', i need to count the number of cells within E6 - H6
which contains the letter 'WO'.

can we count words in a row which has links from other file
 

=COUNTIF(E6:H6,"*WO*")

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


"Vijay" wrote:

The data in workbook A is updated using formulas using the data in workbook
B. Can we count the specific words/letters in the row where the data is
imported in workbook A.

Example: Cells E 6- H6 in work book 'A' contains a formula which imports the
data from workbook 'B', i need to count the number of cells within E6 - H6
which contains the letter 'WO'.

can we count words in a row which has links from other file
 

Hi Jacob, it works thanks.

"Jacob Skaria" wrote:

=COUNTIF(E6:H6,"*WO*")

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


"Vijay" wrote:

The data in workbook A is updated using formulas using the data in workbook
B. Can we count the specific words/letters in the row where the data is
imported in workbook A.

Example: Cells E 6- H6 in work book 'A' contains a formula which imports the
data from workbook 'B', i need to count the number of cells within E6 - H6
which contains the letter 'WO'.