Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Functions
DCOUNT returns the "wrong" number (maybe)
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="dh13134, post: 3872395"] i'm using DCOUNT to count the number of stock tickers in a list that meet my criteria. the problem is, my criteria says to count tickers "A, BA CD and DE" for example, which should return a count of 4. but my list contains "A,AA,BA,BAC,CD,CDI,DE,DET, and DCOUNT returns 8. is this the way DCOUNT works? if i had AXY and AYZ in my list, DCOUNT would count those too. how can i get the answer i want (4)? [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Functions
DCOUNT returns the "wrong" number (maybe)
Top