COUNTIF function in Excel ➕ not blank / less than / greater than / multiple criteria
Автор: Leon Renner
Загружено: 2022-03-21
Просмотров: 3342
Описание:
The COUNTIF function in Excel is a tool with which you can count the number of cells which fulfil a certain condition. You can for example do a COUNTIF not blank but also use this formula with mathematical operations like COUNTIF less than or COUNTIF greater than. And sure enough you can also go for the exact match of a number. So, in this video you will learn how to use the COUNTIF function in Excel.
In the first example of this tutorial, we are going to look at a basic example for this Excel formula. In the second example, we will work with multiple criteria in the COUNTIF function. So for this there exists the COUNTIFS function.
And last but not least we are also going to look at COUNTIF not blank.
Timeline:
00:00 Introduction
00:28 COUNTIF with single criteria
01:45 Possible sources of errors
03:08 COUNTIFS with multiple criteria
05:15 COUNT IF not blank
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: