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!

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!
>

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!
> >