DCount Question

[Kenwalt]

I am trying to insert an array directly into a DCount formula and I keep getting an error.

This formula works fine:

=DCOUNT(Database,field,A1:B2) In this formula A1:B2 are cells containing my criteria.

My problem comes when I try to replace A1:B2 with the actual values. For example:

=DCOUNT(Database,field,{"A17","q01";1,1}) This formula results in a #VALUE! error.

Is it possible to insert the array directly into the DCount Formula?

Thanks in advance

 

[Colin Legg]

Hi and welcome to the forum.

Unfortunately no, you cannot pass an array directly into any of the DCOUNT() parameters. The "D" (database) functions would be much more widely used if this was possible but the current situation is that you must pass in range references.

 

[Kenwalt]

Hi Colin,

That is a disappointing answer but at least now I know.

Thanks for your help.