Posted to microsoft.public.excel.worksheet.functions

GDannyboy

Posts: n/a

How can I use dcount to total the number of columns with entries?

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot table for reporting sales performance	Ram	Excel Discussion (Misc queries)	2	February 6th 06 10:06 AM
TOTAL NUMBER OF ENTRIES	rostroncarlyle	Excel Worksheet Functions	5	December 16th 05 05:21 PM
concatenating and formatting area code and phone number columns	sherri	Excel Worksheet Functions	4	September 1st 05 09:59 PM
I Need to Count Number of Entries Based on Two Criteria	Jones	Excel Worksheet Functions	3	July 14th 05 10:34 PM
Creating a certain number of entries based on a number in a cell	PPV	Excel Worksheet Functions	4	June 16th 05 10:25 PM

All times are GMT +1. The time now is 01:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us