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