COUNT functions in Excel
Channel:
Subscribers:
4,790
Published on ● Video Link: https://www.youtube.com/watch?v=IPS2ezrppCM
In this video I show you how to use the various COUNT functions in Excel.
The COUNT function counts the number of cells that contain numbers only.
Use the COUNT function to get the number of cells that contain numbers in a range.
The COUNTA function counts cells containing any type of information, including numbers and text.
The COUNTA function does not count empty cells.
The COUNTBLANK function counts cells containing no information at all.
The COUNTBLANK function only counts cells which are empty..
The COUNTIF function counts the number of cells that meet a set criteria.
For example, to count the number of the number of employees who have sold more than 100 cars this year.
Music from Bensound.com
Other Videos By Tech Head Online
2020-03-01 | Importing from an External Data Source |
2020-02-17 | Database Basics in Microsoft Access |
2020-02-17 | Charts and Graphs in Excel |
2020-02-17 | Conditional Formatting in Excel |
2020-02-17 | Data Validation in Excel |
2020-02-17 | Sorting and Filtering in Excel |
2020-02-16 | Printing Worksheets in Excel |
2020-02-16 | Manipulating Text in Excel LEFT, RIGHT, MID & CONCATENATE |
2020-02-13 | IF Functions for IGCSE ICT |
2020-02-13 | Nested IF Functions in Excel |
2020-02-13 | COUNT functions in Excel |
2020-02-13 | VLookup & HLookup in Excel 365 |
2020-02-11 | Formatting a Spreadsheet in Microsoft Excel |
2020-02-11 | Microsoft Excel Basics |
2020-02-09 | Spell check and Replace in Word 365 |
2020-02-09 | Hanging Paragraphs in Word 365 |
2020-02-09 | Inserting and Editing Images into Microsoft Word 365 |
2020-02-09 | Creating Tables in Microsoft Word 365 |
2020-02-09 | Microsoft Word Creating Columns and Page Breaks |
2020-02-09 | Microsoft Word Mail Merge #2 Displaying Field Codes |
2020-02-06 | Microsoft Word - Applying Heading Styles |