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

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"

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"

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!

-----Original Message-----
I am trying to use the COUNTA Function in my spreadsheet
to total cells with
the text containing "NH",