How to use Excel COUNT functions

Excel has several functions for counting the number of cells that meet specific criteria:

• COUNT(value1, value2,...): Counts number of cells (or arguments) containing numbers
• COUNTA(value1, value2,...): Counts number of non empty cells (or arguments)
• COUNTIF(range, criteria): Counts number of cells meeting the criteria
• COUNTIFS(range1, criteria1, range2,criteria2,...): Counts number of cells meeting all given criteria
• COUNTBLANK(range): Counts number of empty cells
• There are also functions DCOUNT and DCOUNTA, but I will handle those later

Following video demonstrates the usage of COUNTX-functions:

Tip: If you have difficulties to see the video, try to maximise it from lower right corner: