park_bench Posted March 19, 2008 Posted March 19, 2008 I'm having a stupid day. Can somebody please help me out? I have a spreadsheet and I want to count all the cells in a column that are not blank. What function/operator do I need please? Thanks Ben
Jona Posted March 19, 2008 Posted March 19, 2008 (edited) COUNTA(B1:B5) where B1:B5 is your range. Ref: http://www.contextures.com/xlFunctions04.html#CountA Edited March 19, 2008 by Jona added ref 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now