New Functions in 2007

Excel 2007 introduced 12 new worksheet functions.

AVERAGEIFReturns the average of all the numbers in a range of cells that satisfy a condition.
AVERAGEIFSReturns the average of all the numbers in a range of cells that satisfy multiple conditions.
COUNTIFSReturns the number of cells with a value that satisfy multiple conditions.
CUBEKPIMEMBERReturns a key performance indicator (KPI) property and displays the KPI name.
CUBEMEMBERReturns a member or tuple from the cube.
CUBEMEMBERPROPERTYReturns the value of a member property from the cube.
CUBERANKEDMEMBERReturns the nth or ranked member in a set.
CUBESETReturns the calculated members returned from a cube.
CUBESETCOUNTReturns the number of items in a set.
CUBEVALUEReturns an aggregated value from the cube.
IFERRORReturns a value or if that value generates an error it returns a different value.
SUMIFSReturns 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.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext