?
Solved

Countif of Blanks

Posted on 2012-04-04
5
Medium Priority
?
211 Views
Last Modified: 2012-08-13
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
Comment
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
  • Learn & ask questions
5 Comments
 
LVL 24

Assisted Solution

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

if they truly are blank.
0
 
LVL 13

Accepted Solution

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

or

=COUNTIF(C2:C17,"")
0
 
LVL 9

Assisted Solution

by:Philippe Damerval
Philippe Damerval earned 664 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

by:Saqib Husain, Syed
ID: 37807333
for 2003 you can use

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

Expert Comment

by:Anthony Mellor
ID: 37807396
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question