Office.com results
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 ...
Excel 2003
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...
Excel 2003
AVERAGE
Article Show All Hide All Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 ,number2,...) Number1, number2, ...      are 1 to 30 numeric ...
Excel 2003
Calculate a running balance
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...
Excel 2003
Calculate the average of numbers
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...
Excel 2003
COUNT
Article Syntax: COUNT(value1,value2,...)
Excel 2003
Count occurrences of values or unique values in a data range
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 ...
Excel 2003
COUNTA
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...
Excel 2003
Math and Trigonometry functions
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...
Excel 2003
Subtract numbers
Article Use the minus sign operator or the SUM function to subtract numbers in Excel 2003.
Excel 2003