Categories
Excel

Count cells with text in Excel

In this tutorial, we will learn how to count cells that have text in them. We will use COUNTIF function for this. MS Excel 2021 is used.

Categories
Excel

Use COUNTIF function in Excel

In this tutorial, we will learn how to use COUNTIF function. COUNTIF function is used to count the number of cells that meet a given criteria or condition. MS Excel 2021 is used.

Categories
Excel

Use COUNTA function in Excel

In this tutorial, we will learn how to use COUNTA function, this function is used to count the number of cells, it only count cells with data and does not count any empty cell. Microsoft Excel 2021 is used.

Categories
Excel

Use COUNT function in Excel

In this tutorial, we will learn how to count the number of cells with numerical values in a specified cell range. COUNT function is used to count the number of cells. Microsoft Excel 2021 is used.

Categories
Excel

Use SUMIF function in Excel

In this tutorial, we will learn how to use SUMIF function in MS Excel. This function adds the values in a range that meet a specified criteria or condition.

Use SUMIF function in MS Excel