Maybe my experimentation with it has been wrong.



The problem that I have is that the criteria in all the examples in the documentation (not using any AND statements in examples), expects a criteria statement, such as B1=FY 2010, not a True or a False value. It is referring to DB functions.

Below is the definition of what Criteria is from the Excel Help:

That is not a True or False value. I've tried entering the AND in the criteria similar to the example and it always returns an error. Again, the document says that the AND and OR functions can be used as Criteria in DB function. It appears to me the document I am reading is wrong.

The helpfile that I have says that you can create AND and OR logic in your criteria by correctly laying out (horizontal and vertical) the criteria in a range.

For example, the helpfile says that to create this logic:
Boolean logic: (Salesperson = "Davolio" OR Salesperson = "Buchanan")
you have to lay out the Salespersons as a list in the same column (there's a picture demonstrating it).

If your source document is the helpfile then I think you've misunderstood "AND" and "OR" boolean logic to mean the AND() and OR() worksheet functions. If your document is something else then point us to it?

Thanks, yes, using it within a function as you describe would be able to be done, as you say.

I can't specifically point you to the document, as it is printed, and copyrighted. But I think that the document, on this particular topic, is written poorly. It lists it exactly as I wrote in the initial post. And it has the title on the page that it can be used that way in DB functions. Based on being written that way, and based on the fact that earlier in the document they discussed the AND and OR functions, also exampled the same way, I presumed that was what they meant.

I appreciate the feedback. I think the final thought is that they meant as you described, which then does make sense.