View Single Post
  #1   Report Post  
MikeinNH
 
Posts: n/a
Default 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"