1. Home
  2. Computing & Technology
  3. Spreadsheets
Ted French
Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Excel 2007 COUNTIF

Wednesday September 30, 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>

Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

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

  1. Home
  2. Computing & Technology
  3. Spreadsheets

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

All rights reserved.