View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Baker John Baker is offline
external usenet poster
 
Posts: 98
Default 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