Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Home
Previous
Next
EXCEL COUNTBLANK FUNCTION
The COUNTBLANK
is an Excel function to count blank cells in a
range
or an
array
.
Syntax:
 =COUNTBLANK(range)
Arguments or Parameters:
range:
a cell of range to count blank cells
Objective
: Find the count of blank cells in the range
B3:B20
.
   Step 1
:
Type = sign in cell
E4
Type
COUNTBLANK
Function
 Â
Step 2
:
Select range
B3:B20
Type “)”
Press
Enter
Conclusion
: The
COUNTBLANK
function has counted 2 blank cells.
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS SQL
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
Scroll to Top