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.

=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:

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.

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

"Stefi" wrote:

=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:

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.