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.

I can't explain it, but here is a work-around:
=COUNTIF(B4:B15,B3)
To use more criteria, add COUNTIF's.

Hth,
Merjet

Thanks Merjet, but what I need is to use DCOUNTA. This is the
specification for the task. I already know about the CountIF as I
have mentioned in my first post.

Again, I need to use DCOUNTA due to the project specification
requirement.

Use this as your criteria:

="=c"

--
Regards,
Tom Ogilvy


"Grasshopper" wrote:

Thanks Merjet, but what I need is to use DCOUNTA. This is the
specification for the task. I already know about the CountIF as I
have mentioned in my first post.

Again, I need to use DCOUNTA due to the project specification
requirement.