Countng the number of non blank fields in a table
Hi:
I have a table, and have simple question:
I wish to count the number of entries (i.e non blank records in the table)
=DCOUNT(A3:A80,1,D6:D7)
where d6:d7 say :
File Name
isblank()
I have also tried 0 and a number of other formulations but non appears to work.
Suggestions please.
John Baker
|