Count occurrences of a text string in a range of cells

Hi,

What is the code to count the number of occurrences of a text string in a row? For example, how many times does "Item#" appear in row 10?

I already have the range to search, so logic something like:

Please Login or Register  to view this content.

Thanks,

Lawrence

Hi,.

Assuming 'Item#' is the only text in a particular cell on a row and not embedded within other text in a cell, e.g. 'This is Item#' then a simple

=COUNTIFS(A1:Z1,"Item#") function will do.

Otherwise programatically assuming firstrow, firstcolumn, lastrow, lastcolumn are numeric integers.

Please Login or Register  to view this content.

Rgds

Hi you can use builtin function in vba

Please Login or Register  to view this content.

this will count quantity of "a" strings in row 10

I think Richard, means... =COUNTIF(A1:Z1,"Item#")

No, =COUNTIFS(A1:Z1,"Item#")

[QUOTE=Fotis1991;2806805]I think Richard, means... =COUNTIF(A1:Z1,"Item#")

Indeed - well spotted.

Cheers