Hi all,

I have tried searching for topics commenting on the same problem I have
hadwith no avail.
I am using the DCOUNT formula to count entries in a spreadsheet with
certain criteria.
(=DCOUNT(database,field,criteria))

The problem is the range that I choose as my database spans about 30
columns,
i.e the first field I choose to add a condition on is column A and
other conditions are found in the last column.

I have found that Excel has a problem searching through such a large
database,
basically it doesn't work...

Has anyone else ever come accross this problem and / or could anyone
think of a suitable workaround??

Am I right to think that Excel has this limitation?

Any help appreciated on this one as it is proving a stumbling block in
what has been a successful project so far

somethinglikeant