This pastes the SUM function into cells D12 and E12 and calculates the totals for these columns. Click the Paste button in the Home tab of the Ribbon.Click the Copy button in the Home tab of the Ribbon.Click cell C12 in the Budget Detail worksheet.
The following demonstrates how the total row is completed: Relative referencing serves the same purpose for functions as it does for formulas. The function can be copied and pasted into these cell locations because of relative referencing. However, this function is also needed to calculate the totals in the Annual Spend and LY Spend columns.
The function calculates the total for the Monthly Spend column, which is $1,496.įigure 2.11 "Adding the SUM Function to the Budget Detail Worksheet" shows the appearance of the SUM function added to the Budget Detail worksheet before pressing the ENTER key.įigure 2.11 Adding the SUM Function to the Budget Detail WorksheetĪs shown in Figure 2.11 "Adding the SUM Function to the Budget Detail Worksheet", the SUM function was added to cell C12. This places the range C3:C11 into the function. Click cell C3 and drag down to cell C11.Click the Budget Detail worksheet tab to open the worksheet.The following illustrates how a function can be added to a worksheet by typing it into a cell location: It is important to note that there are several methods for adding a function to a worksheet, which will be demonstrated throughout the remainder of this chapter. With regard to the Budget Detail worksheet, we will use the SUM function to calculate the totals in row 12. The SUM function is used when you need to calculate totals for a range of cells or a group of selected cells on a worksheet. In addition to demonstrating functions, this section also reviews percent of total calculations and the use of absolute references. This section demonstrates a variety of statistical functions that we will add to the Personal Budget workbook. However, when you use a function, you can highlight all the cells that contain values you wish to sum in just one step. This can be very time-consuming if you have to add the values in a few hundred cell locations.
If you use a formula to add the values in a range of cells, you would have to add each cell location to the formula one at a time. Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. A list of commonly used statistical functions is shown in Table 2.4 "Commonly Used Statistical Functions". For example, the SUM function is used to add the values contained in a range of cells. Statistical functions apply a mathematical process to a group of cells in a worksheet. In addition to formulas, another way to conduct mathematical computations in Excel is through functions.
#Statistical calculations in excel how to#
0 kommentar(er)
