| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countng the number of non blank fields in a table
Tom Ogilvy wrote:
Countif restricts itself to the usedrange. This should be well known - it is one of the advantages of countif - but it can be misused. =COUNTIF(A:A,"<") works fine since any cell with a value will be in the used range. For Frank's example, it returns 0 for me and I believe Frank has used the wrong example or misunderstood the consideration. Hi Tom you're right, error in my worksheet Frank |
| Reply |
| 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) | |||
Hybrid Mode
