Search Contextures Sites
Custom Search

Excel Videos - Count Functions

Short video tutorials with Excel counting function tips, for COUNT and COUNTIF.

Excel Count Functions

Count Matching Text

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

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

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

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

More Excel Videos

Excel Videos - Index

Data Entry Tips

Conditional Formatting

VLOOKUP Function

 

 

 

 

More Videos

Excel Videos - Index

Data Entry Tips

Conditional Formatting

VLOOKUP Function

Mouse Shortcuts and QAT

 

 

 

 

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 30, 2016 10:15 AM