Excel functions

Averageifs

The AVERAGEIFS function in Excel calculates the average of a range of cells that meet multiple criteria. The syntax is AVERAGEIFS(averagerange, criteriarange1, criteria1, [criteriarange2, criteria2], …), where 'averagerange' is the range to average, 'criteria_range' is the range to evaluate against the criteria, and 'criteria' specifies the condition that must be met. It is useful for data analysis when dealing with conditional averages.

Sumifs

The SUMIFS function in Excel is used to sum the values in a specified range that meet one or more criteria. Its syntax is SUMIFS(sumrange, criteriarange1, criteria1, [criteria_range2, criteria2], …)

Countifs

The COUNTIFS function in Excel counts the number of cells that meet multiple criteria across multiple ranges. The syntax is COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Maxifs

The MAXIFS function in Excel returns the maximum value from a range that meets one or more specified criteria. Its syntax is MAXIFS(maxrange, criteriarange1, criteria1, [criteria_range2, criteria2], …) and is useful for identifying the highest values under specific conditions.

Minifs

The MINIFS function in Excel returns the minimum value from a range that meets one or more specified criteria. Its syntax is MINIFS(minrange, criteriarange1, criteria1, [criteria_range2, criteria2], …) and helps in finding the lowest values under specific conditions.

Vlookup

The VLOOKUP function in Excel searches for a value in the first column of a table range and returns a value in the same row from a specified column. Its syntax is VLOOKUP(lookupvalue, tablearray, colindexnum, [range_lookup]), commonly used for data retrieval.

Hlookup

The HLOOKUP function in Excel searches for a value in the first row of a table range and returns a value in the same column from a specified row. Its syntax is HLOOKUP(lookupvalue, tablearray, rowindexnum, [range_lookup]), commonly used for data retrieval in horizontal tables.

Match

The MATCH function in Excel searches for a specified value in a range and returns the relative position of that value within the range. Its syntax is MATCH(lookupvalue, lookuparray, [match_type]), and is useful for finding the location of values in arrays.

Index

The INDEX function in Excel returns the value of a cell in a specified row and column from a given range or array. Its syntax is INDEX(array, rownum, [columnnum]), and it is often used in conjunction with other functions like MATCH.

Now

The NOW function in Excel returns the current date and time. Its syntax is NOW(), and it updates every time the worksheet recalculates, making it useful for time-sensitive calculations.

Weekday

The WEEKDAY function in Excel returns the day of the week for a given date, represented as an integer. Its syntax is WEEKDAY(serialnumber, [returntype]), and it can be used to determine what day of the week a specific date falls on.

Weekday

The WEEKDAY function in Excel provides the day of the week as a number corresponding to a specific date, which can assist in scheduling and analysis.

Workday

The WORKDAY function in Excel returns the date that is a specified number of working days before or after a given start date, excluding weekends and holidays. Its syntax is WORKDAY(start_date, days, [holidays]).

Today

The TODAY function in Excel returns the current date, updating automatically each time the worksheet is recalculated. It is useful for time-sensitive calculations and logging dates.

Not

a function in Excel that returns the logical opposite of a given condition. It is often used in logical formulas to reverse the result of a comparison or condition.

Ifs

The IFS function in Excel allows for testing multiple conditions in one formula, returning a value corresponding to the first TRUE condition. This function simplifies nested IF statements for more efficient logical tests.

And

a logical function in Excel that returns TRUE only if all arguments are TRUE. It is commonly used in conjunction with other functions for complex conditional evaluations.

Or

a logical function in Excel that returns TRUE if any of the arguments are TRUE. It is often used in combination with other functions to evaluate multiple conditions.

If

A logical function in Excel that checks whether a condition is met, returning one value for a TRUE result and another for FALSE.

Average

a statistical function in Excel that calculates the mean of a set of numbers. It sums all the values in the specified range and divides by the count of those values.

Min

a statistical function in Excel that returns the smallest number from a given set of values or range.

Max

A statistical function in Excel that returns the smallest number in a specified range of values.

Count

a statistical function in Excel that counts the number of cells in a range that contain numeric values or countable elements.

Sum

a statistical function in Excel that calculates the total of a given set of values or range.

Counta

a statistical function in Excel that counts the number of non-empty cells in a range.

Countif

a statistical function in Excel that counts the number of cells in a range that meet a specified condition or criteria.

Averageif

a statistical function in Excel that calculates the average of a range based on specified criteria.

left

calculates the specified number of characters from the left side of a text string in Excel.

Right

a text function in Excel that extracts a specified number of characters from the right side of a text string.