New Functions in 2007

Excel 2007 introduced 12 new worksheet functions.

AVERAGEIF	Returns the average of all the numbers in a range of cells that satisfy a condition.
AVERAGEIFS	Returns the average of all the numbers in a range of cells that satisfy multiple conditions.
COUNTIFS	Returns the number of cells with a value that satisfy multiple conditions.
CUBEKPIMEMBER	Returns a key performance indicator (KPI) property and displays the KPI name.
CUBEMEMBER	Returns a member or tuple from the cube.
CUBEMEMBERPROPERTY	Returns the value of a member property from the cube.
CUBERANKEDMEMBER	Returns the nth or ranked member in a set.
CUBESET	Returns the calculated members returned from a cube.
CUBESETCOUNT	Returns the number of items in a set.
CUBEVALUE	Returns an aggregated value from the cube.
IFERROR	Returns a value or if that value generates an error it returns a different value.
SUMIFS	Returns the total of all the numbers in a range of cells that satisfy multiple conditions.

AVERAGEIF Returns the average of all the numbers in a range of cells that satisfy a condition.
AVERAGEIFS Returns the average of all the numbers in a range of cells that satisfy multiple conditions.
COUNTIFS Returns the number of cells with a value that satisfy multiple conditions.
CUBEKPIMEMBER Returns a key performance indicator (KPI) property and displays the KPI name.
CUBEMEMBER Returns a member or tuple from the cube.
CUBEMEMBERPROPERTY Returns the value of a member property from the cube.
CUBERANKEDMEMBER Returns the nth or ranked member in a set.
CUBESET Returns the calculated members returned from a cube.
CUBESETCOUNT Returns the number of items in a set.
CUBEVALUE Returns an aggregated value from the cube.
IFERROR Returns a value or if that value generates an error it returns a different value.
SUMIFS Returns the total of all the numbers in a range of cells that satisfy multiple conditions.