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:

Count("Item#") in Range(Cells(FirstRow, FirstColumn), Cells(LastRow, LastColumn))

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.

myresultcell = "=COUNTIF(" & Range("A1").Cells(firstrow, firstcolumn).Address & ":" & Range("A1").Cells(Lastrow, lastcolumn).Address & ",""Item#"")"

Rgds

Hi you can use builtin function in vba

Sub aa()
Cells(1, 1) = Application.WorksheetFunction.CountIf(Rows(10), "a")
End Sub

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