Category: Excel Functions

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …