MS Excel Formulas

The AVERAGEIF function in Excel is used to find the average of a range of cells that meet a certain […]

This function calculates the average from a list of numbers. If the cell is blank or contains text, the cell

COUNTIFS is another Excel function that allows you to count the number of cells that meet multiple criteria within a

COUNTIF is an Excel function that counts the number of cells within a range that meet a specified criteria. This

SUMIFS is another Excel function that allows you to sum up the values in a range of cells based on

SUMIF is an Excel function that adds up the values in a range of cells based on a specific condition.

HLOOKUP stands for ‘Horizontal Lookup’. It is a function in Excel that makes search for a certain value in a

VLOOKUP stands for Vertical Lookup, The VLOOKUP function performs a vertical lookup by searching for a value in the first

The Microsoft Excel LOOKUP function is one of the most popular functions of MS Excel. This Function is categorized under

The FREQUENCY function in Excel help you to calculating the frequency (no of repeated value) of a data set within