software

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=COUNTIF(A:A,quot;gt;0quot;)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;GDannyboyquot; gt; wrote in message
...
gt;I need a better example of dcount. Excel F1 is not helpful.
gt;
gt; What I need is for Excel to produce the number in a cell which equals the
gt; number of cells with entries greater than zero in a given column. I
gt; believe
gt; 'dcount' can do this, but I'm not sure how to write the formula.
gt;
gt; Please help.
gt;
gt; Dan Glenn
gt;