LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DCounta doesn't work Rambo Excel Worksheet Functions 5 August 10th 09 04:26 AM
Dcounta chau Excel Discussion (Misc queries) 4 March 4th 08 12:15 AM
please help with dcounta doyree Excel Discussion (Misc queries) 4 February 2nd 08 12:11 AM
DCOUNTA question Barb Reinhardt Excel Worksheet Functions 0 January 14th 08 10:11 PM
Newly created Get Function is not working when I copied the syntax from a working function CJ Excel Programming 1 January 16th 07 05:28 AM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"