Dcounta & dates

S

Starfishjen

I'm sure this is common but I haven't been able to crack it. I'm trying to
just do a simple count of non blank cells in a date column. I've tried
count, dcount, dcounta etc but experience the same problem.

I've named the database range as TC001, used column numbers and names
respectively and various versions of criteria (direct or in reference cells).
Current formula is =DCOUNTA(TC001,"Test Date 1",T4:T5)

The Formula Result in the fx dialog indicates the right answer (44) but the
visible answer is always zero. I've changed the format of all cells as I
thought Excel might be regarding this as text but to no avail. I would love
to hear any suggestions you may have to fix this.
 
S

Stefi

=DCOUNTA(TC001,T4:T5) works for me nicely, but what is "Test Date 1" string?
Thereis no such argument in DCOUNTA!

Regards,
Stefi



„Starfishjen†ezt írta:
 
S

Starfishjen

Hi Stefi,

Thanks for your reply!

I've got Dcounta(database,field,criteria) in Excel 2003? "Test Date 1" is
the column header of the database holding the data I want to count. If I try
your version I get an error message 'too few arguments'.

Jen
 

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

Top