Categories

## 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

## 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

## 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

## 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

## 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.

Categories

## Switch Rows and Columns using TRANSPOSE in Excel

In this tutorial, we will learn how to use TRANSPOSE function and copy, paste & transpose to switch rows and columns.

Categories

## Use SUM function in Excel

In this tutorial, we will learn how to use SUM function in Excel. This function is used to add all the values in the range cells. You may add individual numbers, cell references, ranges or combination of all three. Microsoft Excel 2021 is used.

Categories

## Use SWITCH function in Excel

In this tutorial, we will learn how can we use SWITCH function in excel, this function is used, switch function checks the value of a cell against another value and returns a corresponding value.

Categories

## Use IFS function in Excel

In this tutorial, we will learn how to use IFS function in excel. IFS function checks whether one or more conditions are true, and returns a value on a first corresponding True condition. IFS function can be used in the place for nested IF functions. Rather than using multiple if functions, IFS function can be used. Microsoft Excel 2021 is used.

Categories

## Use AND function and IF function in Excel

In this tutorial, we will learn about the AND function, and how it is used with the IF function. The AND function only returns the value True or False, but with the IF function it can return the value of our choice. AND function will be nested in IF function. Microsoft Excel 2021 is used.