G
Grasshopper
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 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.