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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I use dcount to total the number of columns with entries? (https://www.excelbanter.com/excel-worksheet-functions/81116-how-can-i-use-dcount-total-number-columns-entries.html)

GDannyboy

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

Peo Sjoblom

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

All times are GMT +1. The time now is 01:30 AM.