I have managed it. In the criteria range, you have to have the two columns
side by side and select both as one range, (without trying to use AND). If
you try using the AND function and the columns are separated, it just does
not work.

Thanks for your help anyway.

DaveF

"Debra Dalgleish" wrote:

You can use two columns in the criteria area, similar to the advanced
filter criteria area shown he

http://www.contextures.com/xladvfilter01.html#Criteria

DaveF2002 wrote:
I am trying to use a DCOUNT function, and need to have two criteria. How do
I use the AND function within the criteria?

I can do it using one criteria at a time, but when I use AND to use two
criteria, I get an error.

What sytax do I use?

Many thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html