How to count rows with text

  • Thread starter Thread starter davegb
  • Start date Start date
D

davegb

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---
 
Back
Top