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 COUNTIF

Wednesday April 29, 2009
Excel 2007 COUNTIF
Excel 2007 COUNTIF
© Ted French
COUNTIF, one of Excel's COUNT functions combines two other commonly used functions - the COUNT function and the IF function.

The COUNT function will tell you the number of cells in a selected range that contain numbers while the IF function allows you to have different results occur depending on whether a specific condition is met or not.

So what COUNTIF will do is count up the number of cells in a range that meets a specific condition.

To find out the details of using this function read the article on the Excel 2007 COUNTIF function.

Related Articles

Comments

November 11, 2008 at 2:51 pm
(1) Joy says:

Really, really helpful! Please keep on posting these tips… Thanks!

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

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

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

All rights reserved.