DCountA - how to apply FALSE condition?

[Jon Johny]

Im using the Dbase functions, such as DCOUNTA and I've encountered a problem with the Data that is counted. My criteria for what to count is i.e. all of 'Dave's' sales. The problem is the formula is counting all of "Dave", 'Dave N' 'Dave S' and 'Dave Brown'

How do I get my formula to count just the exact matches for 'Dave', like a Vlookup with a False condition would?

Thanks

 

[Andrew Poulsom]

Use the criterion:

="=Dave"

 

[Jon Johny]

Your good!!!

 

[Jon Johny]

Is it possible to refrence a cell and have the notation ="="Dan", be applied to the refrenced text? ("Dan" is jus the text in the example)

Thanks

 

[Jon Johny]

Use the criterion:

="=Dave"

'=Dave --> would work too? right

 

[Andrew Poulsom]

Yes you can use a formula like ="="&A1 and '=Dave will alos work.