Article Show All Hide All Let's say you want to sum prices for all items not on sale in a store or sum gross profit margins for all departments under budget. There are ...

Article Let's say you want to sum the total time a set of tasks will take so that you can calculate a contract rate, or you want to sum the number of minutes in differe...

Article Show All Hide All Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 ,number2,...) Number1, number2, ...      are 1 to 30 numeric ...

Webpage

Article Let's say you may want to see a running balance of items that you purchase so that you don't exceed your spending limits. You can use a running balance to watch...

Article Show All Hide All Let's say you want to find the average number of days to complete a milestone i n a project or the average temperature on a particular day ove...

Article Syntax: COUNT(value1,value2,...)

Article Show All Hide All Let's say you want to find out how many unique values exist in a range that contains duplicate values. For example, if a column contains: The ...

Article Show All Hide All Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contai...

Article Function Description ABS Returns the absolute value of a number ACOS Returns the arccosine of a number ACOSH Returns the inverse hyperbolic cosine of a number A...

Article Use the minus sign operator or the SUM function to subtract numbers in Excel 2003.