Exceljet

Quick, clean, and to the point

Excel 2007

The functions below were introduced in Excel 2007, and are available in later versions, including Excel 365.

Excel AVERAGEIF function

The Excel AVERAGEIF function calculates the average of numbers in a range that meet supplied criteria. AVERAGEIF criteria can include logical operators (>,,=) and wildcards (*,?) for partial matching....

Excel AVERAGEIFS function

The Excel AVERAGEIFS function calculates the average of numbers in a range that meet one or more criteria. The criteria used for AVERAGEIFS can include logical operators (>,,=) and wildcards (*,?) for partial matching....

Excel COUNTIFS function

The Excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS can be used with criteria based on dates, numbers, text, and other conditions. COUNTIFS supports logical operators (>,...

Excel IFERROR function

The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.

Excel SUMIFS function

SUMIFS is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when corresponding cellsĀ meet criteria based on dates, numbers, and text. SUMIFS supports logical operators (>,...