Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
photo of Ted French

Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Excel 2007 COUNT Function

Saturday June 13, 2009
Yet another of Excel's group of Count Functions is the COUNT function itself.

In general this group of functions is used to total the number of cells in a selected range. Each function, however, has a specific job. The COUNT function's job is to only add up those cells that contain numbers.

It ignores empty cells or those containing text. So if you need to know how many cells contain numbers or dates in a spreadsheet the COUNT function will do the job for you.

To find out the details about using this function, read the article on the Excel 2007 COUNT Function.

Related Articles

Comments

November 14, 2008 at 12:07 pm
(1) John says:

Thank you Ted. I found this while searching for Functions()

June 14, 2009 at 12:49 am
(2) Nivaldo Scotti says:

I don’t work with divided cels in excell 2007. After I entering data Excell display #VALUE!
If I copied this formula =a1/b1 the other sheet to my sheet bellow, the error is #value!
Do you help-me?

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Discuss

Community Forum

Explore Spreadsheets

About.com Special Features

Build Your Own Website

Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >

Connect Your Home Computers

Easy ways to connect two computers for networking purposes. More >

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.