Solved

# Countif of Blanks

Posted on 2012-04-04
208 Views
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?
0
Question by:cansevin
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 24

Assisted Solution

StephenJR earned 167 total points
ID: 37807286
=COUNTBLANK(C2:C27)

if they truly are blank.
0

LVL 13

Accepted Solution

Shanan212 earned 167 total points
ID: 37807288
=COUNTBLANK(C2:C27)

or

=COUNTIF(C2:C17,"")
0

LVL 9

Assisted Solution

Philippe Damerval earned 166 total points
ID: 37807304
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

LVL 43

Expert Comment

ID: 37807333
for 2003 you can use

=ROWS(C2:C27)-COUNTA(C2:C27)
0

LVL 9

Expert Comment

ID: 37807396
if you know the number of rows involved then this does it:

=24-COUNT(C2:C25)

edit: actually, the comment above with =counta() is better
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month7 days, 11 hours left to enroll