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)