Staff Skills academy+
Home » Courses » Microsoft Excel for Beginners Certification » Module 20 : COUNTBLANK
Module 20 : COUNTBLANK
20.1 COUNTBLANK The COUNTBLANK formula counts the number of empty cells in a specified range. If you are putting together a database of information, for example, the COUNTBLANK formula could help you determine how much information still needs to be filled out. The formula for the function is: =COUNTBLANK(range) This function counts cells that return empty formulas, and those not yet filled out. However, cells with a zero value are counted. Note that you need to turn off the iterative f...
Lessons
- Module 1 : Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : AVERAGE
- Module 14 : AVERAGEIF
- Module 15 : SUMIF Formula
- Module 16 : IF Formula
- Module 17 : VLOOKUP
- Module 18 : HLOOKUP
- Module 19 : COUNTIF Formula
- Module 20 : COUNTBLANK
- Module 21 : COUNTA Formula
- Module 22 : COUNT Formula
- Module 23 : CONCATENATE
- Module 24 : TRANSPOSE
- Module 25 : DATE Formula
- Module 26 : MONTH Formula
- Module 27 : Pivot Tables
- Module 28 : Pie Charts
- Module 29 : Doughnut Charts
- Module 30 : Line Charts
- Module 31 : Column Charts
- Module 32 : Bar Charts
- Module 33 : Number Formatting
- Module 34 : Create Borders
- Module 35 : Conditional Formatting
- Module 36: Comments
