A To Z of Excel Functions | New Functions Introduced In 2007
New Functions in 2007 Excel 2007 Introduced 12 New Worksheet Functions. Read up other functions here. 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 ...