From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,900 courses taught by industry experts.
Count nonblank cells with COUNTA - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Count nonblank cells with COUNTA
- [Instructor] The COUNTA function counts the number of cells within a range that contain any value at all. It returns the number of non-empty cells. This is different than the COUNT function that only counts cells that have numbers or date and time values. This is a way that these students have been approved for the photography class. Their presence has all been recorded in different ways. Equal sign CountA and we'll select the range. Close the parentheses and there's our value. I can do this using lowercase, that's perfectly fine, too. This is an easy way to tell us how many students signed up for each class.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.