MS Excel Formulas

The PRODUCT function in Excel is used to multiply numbers together. It takes one or more arguments, separated by commas, […]

The SUMPRODUCT function in Excel is used to multiply corresponding elements in two or more arrays, and then sum the

The SUBTOTAL function in Excel is very helpful to analyze data of provided range. The SUBTOTAL Function allow to make

COUNTBLANK function is a formula used to count the number of empty cells within a specified range. It helps you

Count means to count or calculate. In the same way, count function is used in excel when we have to

COUNTA function counts cells containing any type of information, including error values and empty text (“”). The COUNTA function does

MATCH() returns the position of a cell in a row or column. The Excel MATCH function searches for a lookup

INDEX() returns the value of a cell in a table based on the column and row number. The INDEX function

The INDEX MATCH Formula is the combination of two functions in Excel which is INDEX and MATCH. INDEX and MATCH

The AVERAGEIFS function in Excel is similar to AVERAGEIF but allows you to find the average of a range of