Search Contextures Sites

 

 

Learn how to create Excel dashboards.

 

Excel Tutorial Videos 12

Excel Count Functions
Excel COUNTIF Function - Count Matching Text
Excel COUNTIF Function -- Count Items Greater Than Set Amount

Excel Count Functions

Use Excel count functions to count worksheets cells that contain numbers only, or to count cells with any type of data, or to count blank cells. This video shows the COUNT function, the COUNTA function, and the COUNTBLANK function, and warns of the quirks in counting some types of cells.

For written instructions for this Excel video tutorial, see the full article: Excel Count Functions -- Count Excel Cells

Excel COUNTIF Function -- Count Matching Text

Use Excel COUNTIF function to count cells in a list that contain specific words or part of a word. For example, how many orders were there for a Pen? How many orders were placed for any kind of pen, such as "Gel Pen", "Pen" or even a "Pencil"?

For written instructions for this Excel video tutorial, see the full article: Excel Count Functions -- Count Excel Cells

Excel COUNTIF Function -- Count Items Greater Than Set Amount

Use Excel COUNTIF function to count the number of items in a list that are over or under a specific amount. For example, find the number of students with scores above the passing grade. Use a cell reference in the Excel COUNTIF function to make the formula flexible and more powerful.

For written instructions for this Excel video tutorial, see the full article: Excel Count Functions -- Count Excel Cells

 

   

 

Excel Tutorial Videos 01
Excel Tutorial Videos 02
Excel Tutorial Videos 03
Excel Tutorial Videos 04
Excel Tutorial Videos 05
Excel Tutorial Videos 06
Excel Tutorial Videos 07
Excel Tutorial Videos 08 
Excel Tutorial Videos 09 
Excel Tutorial Videos 10  
Excel Tutorial Videos 11  
Excel Tutorial Videos 12  

 

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright ©2012
All rights reserved.

 

Last updated: November 7, 2010 10:43 PM