LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Counting Non Blank Cells Lindsey Excel Discussion (Misc queries) 4 April 8th 09 06:41 PM
Counting Non Blank Cells AJ[_2_] New Users to Excel 6 March 27th 08 11:06 PM
Counting non-blank cells Joe M. Excel Discussion (Misc queries) 7 July 23rd 07 09:36 PM
Counting non-blank cells in a column, excluding hidden rows SisterDell Excel Worksheet Functions 3 June 1st 07 03:31 PM
counting blank cells bdq17 Excel Discussion (Misc queries) 6 December 7th 05 08:46 PM


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"