Dcounta & dates
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 & dates
=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. |
Dcounta & dates
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. |
All times are GMT +1. The time now is 03:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com