Thread: How can I use dcount to total the number of columns with entries?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GDannyboy
 
Posts: n/a
Default 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 QuoteReply With Quote