Using Formulas and Functions in Microsoft Excel 2013
- 4/15/2013
- Creating simple cell formulas
- Assigning names to groups of cells
- Using names in formulas
- Creating a formula that references values in an Excel table
- Creating formulas that reference cells in other workbooks
- Changing links to different workbooks
- Analyzing data by using the Quick Analysis lens
- Summing a group of cells without using a formula
- Creating a summary formula
- Summing with subtotals and grand totals
- Exploring the Excel function library
- Using the IF function
- Checking formula references
- Debugging your formulas
Summing a group of cells without using a formula
Sometimes, such as when you’re entering data into a worksheet or you’re curious to find out the sum or average of the values in a few cells, it’s too much work to find a blank cell and write a formula to calculate the sum or average for the cells. Rather than make you create a separate formula, Excel counts the number of cells selected, calculates a running total and average for the currently selected cells, and displays the results on the status bar. Finding the sum, average, and count of the values in the selected cells are the most commonly used operations, so Excel calculates those values by default. However, you can choose from several other operations, or you can even tell Excel not to calculate a running total for any selected cells.
Summarize data in a group of cells
Select the cells that you want to summarize to have the summary appear on the status bar.
)
Find the total, average, or other values of cell data
Right-click the status bar, and choose the summary operations that you want from the shortcut menu.
