COUNT functions in Excel

Subscribers:
4,790
Published on ● Video Link: https://www.youtube.com/watch?v=IPS2ezrppCM



Duration: 3:45
8 views
0


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