strings as criteria in database function DCOUNT

R

Rob

I have a problem with using strings as criteria in the database function
DCOUNT. If I use a criterium such as "loc1", it counts all the locations
starting with "loc1", so also "loc10", "loc1b" "loc11". For example:
=dcount(database;criteria) return 3, where it would like it to return 1

criteria:
location name
loc1 a

database:
location name
loc1 a
loc10 a
loc10 a

I know i could prevent it by using loc01, but i would like to know if there
is a button or switch somewhere that also does the trick. And does anyone
know if this function perforedm differently in older version of excel?
(pre-2000)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top