I am afraid this still does not work.
Any other suggestions?

Thanks for your help
Gemma

"Jim Cone" wrote:


Dcount is used to count numbers, use DcountA to include text.
Also, you must specify the column to look in as the second argument.
And the third argument should specify the criteria range.
So if the data is in A1:G16 and the criteria range is H1:N3 then...
=DCOUNTA(A1:G16,"Venue",H1:N3)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"FarmerGemGem"

wrote in message
I have these criteria(all need to be fulfilled):

Date Venue Ticketype Postcode

However I want to be able to enter two venues sometimes, and only one other
times. I use Dcount, however it does not work, if I have two criteria one
beneath the other eg:
Venue
York
Castle

=DCOUNT(Data!A1:G200,,A10:F12)