Try this:

=COUNTIF(A:A,"*NH*")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"MikeinNH" wrote in message
...
I am trying to use the COUNTA Function in my spreadsheet to total cells
with
the text containing "NH", however, the function sees everything after the
comma as "value2" and gives an error, the cell does show the total
"non-blank" fields and then incriments the number by 1 (so instead of 67
cells it totals 68). The total number of "NH" cells is 48"