# How to Calculate Labor Cost in Excel

## experto.de

### How to calculate subtotals in Excel 2010

tip: Mastering Excel - In no time you will get to know the new Excel from the Basics Up to the
Professional functions
.

### 1. Calculation of partial results using the "partial result" formula

• Stand on a blank line below your table.
• Leave space between the formula and the last row in the table.
• Enter the following formula:
= partial result (function; area of ​​the table)

1 AVERAGE
2 NUMBER
3 NUMBER2
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STABWN
9 SUM
10 VARIANCE
11 VARIANCES

### Example of a calculation

Summation of partial results (see Figure 1): The table has an auto filter in column A (product) + B (price). Line 13 contains the formula "partial result".

### Result

If you use the autofilter in this example to filter in column A (products) for the product trousers, then it calculates the subtotal for the product trousers (see Figure 2).

### 2. Calculation of partial results using the partial result function on the toolbar

The function can be found under Excel 2007-2010.

• Data tab
• Group outline
• Partial result function

### Example of a table

 road floor Surname electricity Elbestrasse 1st floor Beate Scheuer 444,82 € Elbestrasse 1st floor Lars Eckbert 286,32 € Elbestrasse 1st floor Helmut Doll 506,18 € Elbestrasse 2nd Floor Markus Eckbert 429,49 € Elbestrasse 2nd Floor Meike Knoll 332,34 € Elbestrasse 2nd Floor Kirsten Schmitz 265,87 € North street 1st floor Thomas Bauer 384,82 € North street 1st floor Peter Palmer 316,15 € North street 1st floor Susanne Stein 296,78 € North street 2nd Floor Sven Sommer 333,67 € North street 2nd Floor Miriam Ballweg 412,70 € North street 2nd Floor Karin Hopkins 283,92 €

(Source: Herdt-Verlag)

Tip: The table must be sorted in ascending order in the 1st column and does not contain any formulas or calculations, because formulas are only inserted with the "partial result" function.

### How do you create a partial result using the "partial result" function on the "data" tab?

Excel 2007-2010

• Mark the table
• Data tab
• Group outline
• Partial result function
• Select the grouping in the mask that then appears. In our example, we grouped by street. Select the "Sum" function in the "Using after" field. In our example, click on the "Current" field in the "Add partial result to" field.
• The following options are also selected in this mask:
• Replace existing partial results,
• Show results below the data.

### Result

The table is grouped in column A (street) and in column D (current) the current is totaled as a partial total for each street. A total is displayed below the table:

 road floor Surname electricity Elbestrasse 1st floor Beate Scheuer 444,82 € Elbestrasse 1st floor Lars Eckbert 286,32 € Elbestrasse 1st floor Helmut Doll 506,18 € Elbestrasse 2nd Floor Markus Eckbert 429,49 € Elbestrasse 2nd Floor Meike Knoll 332,34 € Elbestrasse 2nd Floor Kirsten Schmitz 265,87 € Elbestrasse result 2.265,02 € North street 1st floor Thomas Bauer 384,82 € North street 1st floor Peter Palmer 316,15 € North street 1st floor Susanne Stein 296,78 € North street 2nd Floor Sven Sommer 333,67 € North street 2nd Floor Miriam Ballweg 412,70 € North street 2nd Floor Karin Hopkins 283,92 € Nordstrasse result 2.028,04 € Overall result 4.293,06 €

(Source: Herdt-Verlag)

### 3. Calculation of partial results using the dynamic table

Excel 2007-2010

• Create table with column headings
Tip: The table must not have an auto filter
• Mark the table
• Start tab
• Group styles
• Format as a table
Click on the "Table has a heading" function

### Result

• An auto filter is inserted in the first column of the table.
• Another tool "Table Tools" will be added to the top right of the screen.
• This tool has 1 tab: Design (see Figure 3).
• In this tab, click on the "Options for table format" function and click on the "Result line" option.
• A result line is inserted below the table.
• Click in this result line. You will then see a pull-down arrow next to the respective cell (see Figure 4).
• With this you can set a calculation type for the respective column. The calculation corresponds to the "partial result" formula (see point 1 above).

### PS: Quality management is important to us!

Please let us know how you like our post. To do this, click on the asterisks shown below (5 asterisks = very good):