| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use dcount to total the number of columns with entries?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use dcount to total the number of columns with entries?
=COUNTIF(A:A,"0")
-- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "GDannyboy" wrote in message ... I need a better example of dcount. Excel F1 is not helpful. What I need is for Excel to produce the number in a cell which equals the number of cells with entries greater than zero in a given column. I believe 'dcount' can do this, but I'm not sure how to write the formula. Please help. Dan Glenn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| TOTAL NUMBER OF ENTRIES | Excel Worksheet Functions | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
Hybrid Mode
