LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Don
 
Posts: n/a
Default Counting Cells

I have a column of numbers, 1-31. Each number is the number of a day of the
month. Some days are missing and a blank has been left for those days (in
the column).
Can someone help me with this problem? I want to return the count for the
days that are listed (omitting the blanks) but I only want to count the days
that are less than or equal to =day(today()). Can someone show me how to
write this? It's driving me mad. Thanks for any help.
--
Don Rountree
 
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 the number of cells meeting conditional formating criteria Jeff Excel Worksheet Functions 4 July 9th 05 01:18 AM
Counting unique text/number cells from a range sudeepd12 Excel Worksheet Functions 2 June 14th 05 11:21 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 2 May 2nd 05 08:53 AM
complex fomula: counting cells that are blank shmurphing Excel Worksheet Functions 2 January 6th 05 09:55 PM
Counting blank cells in Pivot Table Andy Joyce Excel Worksheet Functions 1 December 21st 04 10:05 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"