counting instances of predefined text in a row
 

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

counting instances of predefined text in a row
 

Try the COUNTIF Function.

From MS documentation:-

=COUNTIF(B2:B25,"Nancy")

Please hit yes if my comment has helped.

Thanks.

"Zing" wrote:

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

counting instances of predefined text in a row
 

before/after examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zing" wrote in message
...
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

counting instances of predefined text in a row
 

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")+COUNT IF(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

"Zing" wrote:

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