View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grasshopper[_2_] Grasshopper[_2_] is offline
external usenet poster
 
Posts: 7
Default DCOUNTA function not working right

Hi all,

I am not quite sure if I did it right or there is something wrong with
the DCOUNTA function. Basically, I want to count the number of cells
that contains the letter "c" and "c" only (as the whole value in the
cell). A screen shot is provided at this link: http://www.f12f.com/dcounta.gif

As shown, the function also includes "cat" and "cap" - which is not
what I needed.

Could anyone help? The correct number should be 2.

I know this can be done using COUNTA function, but my employer wants
to use DCOUNTA to account for multiple criteria in the future.

Thanks.