August 2, 2021

## SUMPRODUCT function in Excel

SUMPRODUCT function is used when you want to first multiply two or more ranges or arrays together and then get its sum in Excel. It …

## SUMIFS function in Excel

In this lesson we will learn how the SUMIFS function works in Excel. The SUMIFS function returns the sum of the cells that meet a …

## SUMIF function in Excel

In this lesson we will learn how the SUMIF function works in Excel. The SUMIF function returns the sum of the cells that meet a …

## TODAY function in Excel

In this lesson we will learn the usage of TODAY function in Excel. TODAY function is used to get the current date. It can be …

## COUNTIF function in Excel

In this lesson we will learn the usage of COUNTIF function in Excel. The COUNTIF function returns a number that represents the number of cells …

## COUNTIFS function in Excel

In this lesson we will learn the usage of COUNTIFS function in Excel. The COUNTIFS function returns the count of the cells that meet a …

## COUNTA function in Excel

In this lesson we will learn how the COUNTA function works in Excel. The COUNTA function is used to count the number of non-blank cells …

## MATCH function in Excel

In this lesson we will learn the use of MATCH function in Excel. The MATCH function is used to get the position of a specific …

## NOT function in Excel

In this lesson we will learn how the NOT function works in Excel. The NOT function is used when you want to reverse the value …

## REPT function in Excel

In this lesson we will learn about the REPT function in Excel. The REPT function is used when you want to repeat a specified text …