Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Use the COUNT function to count cells containing numeric data
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

To count all cells that contain numbers, use the COUNT function. Please note that all empty cells, logical values, text, and error values will be ignored. Here is the syntax that is used:
COUNT(value1, value2, …)
value1, value2, …: From 1 to 30 arguments of any type of data. However, all but numeric data is ignored.

To count the number of cells that contain numbers:

  1. In cells A1:A10 type data (numeric and text).
  2. Select cell C1 and type the following formula: =COUNT(A1:A10).
  3. Press Enter.

Use the COUNT function to count cells containing numeric data

Arguments that are date and time values are counted as numeric too.

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

Use the COUNT function to count cells containing numeric data
  1. How to Use the COUNTA function to count cells containing data
  2. How to Use the COUNTBLANK function to count empty cells
  3. How to Use the COUNTA function to count cells containing text
  4. How to count sets of cells located in two columns in Excel
  5. How to Utilize Data Entry Rules to Validate data in Excel 2007

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the ROUND function to round numbers in Excel
How to check for future dates using TODAY Function in Excel →