Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DCounta doesn't work | Excel Worksheet Functions | |||
Dcounta | Excel Discussion (Misc queries) | |||
please help with dcounta | Excel Discussion (Misc queries) | |||
DCOUNTA question | Excel Worksheet Functions | |||
Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming |