Countif of Blanks

How do I do a "countif" formula for blank cells? I want it to count the blank cell from C2:C27, any idea how to do this?
cansevinAsked:
Who is Participating?
 
Shanan212Commented:
=COUNTBLANK(C2:C27)

or

=COUNTIF(C2:C17,"")
0
 
StephenJRCommented:
=COUNTBLANK(C2:C27)

if they truly are blank.
0
 
Philippe DamervalSenior Analyst ProgrammerCommented:
Which version of excel?
If it is the latest, you can achieve this by typing this formula:
=COUNTBLANK(C2:C27)
You can count the nonblank values by typing:
=COUNTA(C2:C27)

HTH,

Philippe
0
 
Saqib Husain, SyedEngineerCommented:
for 2003 you can use

=ROWS(C2:C27)-COUNTA(C2:C27)
0
 
Anthony MellorChartered AccountantCommented:
if you know the number of rows involved then this does it:

Count if blank simple
=24-COUNT(C2:C25)


edit: actually, the comment above with =counta() is better
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.