How to use COUNTA, COUNTIF and COUNTIFS in Microsoft Excel | COUNTA | COUNTIF | COUNTIFS

This video shows how to use COUNTA, COUNTIF and COUNTIFS to count the text and number of cells that meet a criterion or multiple conditions; for example, to count the number of times a particular city appears in a customer list.

In this video, I run through the following:
1) Count how many times a certain string or number appear in a list
2) Count how many times multiple items appear in a list
3) Count how many items are greater than or less than a certain value
4) Count how many items are between certain values
5) Count how many items do not match certain values
6) Count how many items begin or end with certain characters
7) Count how many items match certain conditions across multiple columns

Lastly, I cover how to use Excel for free on the web. Excel on the web supports the COUNTIF and COUNTIFS functions.

Видео How to use COUNTA, COUNTIF and COUNTIFS in Microsoft Excel | COUNTA | COUNTIF | COUNTIFS канала Jide Olasehinde