COUNTA Function not working =COUNTA(C3:C69,"NH")

[MikeinNH]

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"

 

[Ragdyer]

Try this:

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

 

[Andrew]

I think it's the COUNTIF function you want to use.

=COUNTIF(C3:C69,"NH")

Check of your Help on this function for more details on
other way of using this function.

Good luck!