January 24, 2022

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 …