Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

can DCOUNT use formulae for it's ranges?

Posted by Gavin on November 01, 2001 1:23 AM

I am using =DCOUNT(database,field,criteria)

No problem but I would like to use a formula for the 'database' , 'field' and 'criteria' parts something along the lines of.

=DCOUNT(CONCATENATE(a1,":",z1),VLOOKUP(x,y,z),CONCATENATE(b2,":",z2))

but all I get is a #VALUE error message

is there a universal rule about not being able to use formulae where excel is expecting a name or range?

I use Excel 2000 on NT

what is in b1 and z1, also b2 and z2?

Posted by Ian Mac on November 01, 2001 4:22 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.