Thread: COUNTA failing?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default COUNTA failing?

COUNTA simply counts the number of nonblanks in the range(s) you specify and
any values you input as arguments. In your case there is nothing in D2:D4
and you specified one other argument. Therefore the result of 1 is correct.
You could put anything in cell d3 and the result would always change to 2.
You can even insert a value that results in an error (like =NA() or =1/0).

As Dave mentioned, I think you are using the wrong function. If you want it
to count the number of cells in D2:D4 that contain "jones" use this formula

=COUNTIF(D2:D4,"Jones")