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>

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

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

  1. Home
  2. Computing & Technology
  3. Spreadsheets

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

All rights reserved.