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 COUNTA Function

Monday June 8, 2009
There are a number of functions in Excel that will count cells for you rather than add or multiply the data in those cells. One of these COUNT functions that I use regularly is the COUNTA function. I use it to keep track of the number of students I have in each of my classes.

COUNTA tells you the number of non-blank cells that are present in a specified range. The cells can contain numbers, dates, or just plain text labels.

To find out the specifics of about this function read the article on Excel 2007 COUNTA Function.

Related Articles
Comments

No comments yet. Leave a Comment

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.