How to count rows with text
 

Can someone tell me a simple way to count the number of occurences of
a text string "abc" that are in adjacent columns in a row? In other
words, in row 2, starting in column "B" I have "abc". It appears again
in column C, and so forth. At some point, the contents of the cells in
row 2 changes to "xyz". I need to know how many "abc"s are there so I
can copy them to another spreadsheet. Can someone show me a good way
to do something like this?
Thanks in advance!

How to count rows with text
 

hi,
=countif(2:2,"abc")
or
count the number of time "abc" appears in row2.

Regards
FST1

"davegb" wrote:

Can someone tell me a simple way to count the number of occurences of
a text string "abc" that are in adjacent columns in a row? In other
words, in row 2, starting in column "B" I have "abc". It appears again
in column C, and so forth. At some point, the contents of the cells in
row 2 changes to "xyz". I need to know how many "abc"s are there so I
can copy them to another spreadsheet. Can someone show me a good way
to do something like this?
Thanks in advance!

How to count rows with text
 

FSt1 is right, for a specific string, use something like this:
=COUNTIF(A1:A100,"ABC")

To count all rows with text, sue something like this:
=COUNTA(A1:A100)


Regards,
Ryan---


--
RyGuy


"FSt1" wrote:

hi,
=countif(2:2,"abc")
or
count the number of time "abc" appears in row2.

Regards
FST1

"davegb" wrote:

Can someone tell me a simple way to count the number of occurences of
a text string "abc" that are in adjacent columns in a row? In other
words, in row 2, starting in column "B" I have "abc". It appears again
in column C, and so forth. At some point, the contents of the cells in
row 2 changes to "xyz". I need to know how many "abc"s are there so I
can copy them to another spreadsheet. Can someone show me a good way
to do something like this?
Thanks in advance!