Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default number formats for pivot table fields | Excel Discussion (Misc queries) | |||
Max Number Fields/Columns In Pivot Table | New Users to Excel | |||
Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table problem, blank fields aren't being added | Excel Discussion (Misc queries) |