articles

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 »

www.reference.com 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 »

www.reference.com Technology Software

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

www.reference.com 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 »

www.reference.com 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 »

www.reference.com 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 »

www.reference.com Technology Software

To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single column. To calculate the first quartile, select a blank cell, and ente... More »

www.reference.com Technology Software