Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the COUNTBLANK function to count empty cells
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

Occasionally it is may be useful to determine how many cells in a range are empty. You can use the COUNTBLANK function to count all empty cells in a range of cells. Here is the syntax that is used:
COUNTBLANK(range)
range: The range in which to count blank cells.

To count all empty cells in a specified range:

  1. In cells A1:A10 type data (numeric and text). Be sure to
    leave a few cells empty.
  2. Select cell C1 and type the following formula: =COUNTBLANK(A1:A10).
  3. Press Enter.

How to Use the COUNTBLANK function to count empty cells

This tip is compatible with Excel 97, 2000, 2003 and 2007.

How to Use the COUNTBLANK function to count empty cells
  1. Use the COUNT function to count cells containing numeric data
  2. Conditional Average formula that ignores empty cells in Excel
  3. How to Use the COUNTA function to count cells containing data
  4. How to Use the COUNTA function to count cells containing text
  5. How to count sets of cells located in two columns in Excel

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← How to Create a Custom Number Format in Excel 2003 & 2007
Summary of the most Commonly used VBA Built-in Functions →