LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sbrimley
 
Posts: n/a
Default counting nonblank cells

I have a student list that is constantly being added to throughout the year
and I need a formula that would count the number of students on the whole
excel sheet without having to scroll down to see how many rows there are. I
have used the count row function but I don't particularly care for it in this
file. I have been playing around with the different count functions but I
have not found one that works. Is there a function that counts non blank
cells?
Any suggestions
Excel 2002
A1:5000
first name

Thanks Suzanne
 
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 cells, similar values SteW Excel Worksheet Functions 7 May 12th 05 07:05 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 2 May 2nd 05 08:53 AM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 12:47 AM
counting cells with conditional formatting applied HalB Excel Discussion (Misc queries) 3 February 21st 05 01:21 PM
Counting nonblank and non white space cells Andrew Excel Worksheet Functions 6 February 8th 05 04:33 AM


All times are GMT +1. The time now is 05:24 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"