Dcount with Multiple Criteria

C

conord

Hey,
Got this problem which is really bugging me.

I have an array which I need to get information from.
the information is to count the amount of entries which fall into
specific brackets
<£1mil turnover and <1300 employees

I have used the Dcount function to do this . (and created 24 arrays,1
for each set of criteria)

but I need to add another criteria which occurs in another field of the
array.

This field has 16 variables so rather then make a huge messsy array, is
their a way of linking criteria together

Dcount(DATA, "turnover" , "Quad1 criteria AND Industry Criteria")

I have tried & and AND and a whole load of other functions but I would
love a bit of help

Thanks a million

Regards

Conor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCOUNT Help 2
How do I use DCOUNT with evaluation of multiple columns? 4
Page numbering with Merged Document and IF statements 1
String criteria in DCOUNT function 0
Using countif with multiple criteria 0
strings as criteria in database function DCOUNT 2
DCOUNT or nested functions? 2
SUMIF and multiple criteria 3

Top