Some common Excel formulas include SUM, which calculates the sum of values within a specified range of cells, COUNT, which counts the number of cells that have characters or numbers in them, and INT, which eliminates the... More » Technology Software

Use of tutorials and guides that provide helpful instructions can help you learn to create Excel formulas, and practicing these spreadsheet tools reinforces the knowledge. Use a guide to Excel spreadsheet equations, such... More » Technology Software

Find various cheat sheets for formulas and functions in Microsoft Excel 2003 and newer versions on websites such as and the TechTarget section of An illustrated cheat sheet for Microsoft Excel can... More » Technology Software
similar articles

Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represents the values in cells to be summed. More » Technology Software

A cumulative sum is a total amount resulting from the addition of several values. In Microsoft Excel specifically, it is a value reached by adding the numbers in a group of columns or rows. More » Technology Software

To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula. More » Technology Software

Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is being determined. This range is either a row or a column of cell... More » Technology Software