counting instances of predefined text in a row

[Zing]

Hi

Sorry am new to this.

Can someone please tell me how I can get the total at the end of a row that
text like Mid, Har,Yor, Sto is entered into cells. I also ahave number in
cells in the rows that I do not want to count

Thanks

 

[trip_to_tokyo]

Try the COUNTIF Function.

From MS documentation:-

=COUNTIF(B2:B25,"Nancy")

Please hit yes if my comment has helped.

Thanks.

 

[Don Guillett]

before/after examples

 

[Gil]

Hello Zing,

This probably isn't the cleanest of formulas, but I use one just like it for
three different values. Try this:

=COUNTIF(A1:A10,"Mid")+COUNTIF(A1:A10,"Har")+COUNTIF(A1:A10,"Yor")+COUNTIF(A1:A10,"Sto")

Obviously change the ranges to what suits your spreadsheet and if you insert
lines, the formulas will adjust auto-magically.

Hopefully I've helped and if this post has been helpful to you (or anyone
else) - please click the Yes button.

Gil