MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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

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

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