View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Counting Blank Cells until end of Column

I know how to count all database entries that have a close date.
The problem lies in counting all entries that don't have any date in the
cell.
I need to count all the cells that are blank but only until the last row
that has recently been filled in. Is there a way to say count blanks until
end? or Count only if another column is filled out and if the date closed
field is blank? Any thoughts?