To return to the previous section of this article, click Create a total based on multiple conditions

Experienced Excel users may want to understand the formulas that the wizard creates.

Here is the formula for South region sales:

Here is more information about the parts of this formula:

• The braces enclosing the formula indicate that it's an array formula, a type of formula that can perform multiple calculations using multiple cells. When you edit an array formula, you must press CTRL+SHIFT+ENTER to store your changes to the formula in the cell.

  For more information about array formulas, type array formulas in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

• SUM and IF are worksheet functions, which are predefined formulas that perform calculations using values that you specify. For more information about using functions, type worksheet functions in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

  For more information about SUM and IF, type SUM or IF in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

• The dollar signs in the cell references indicate absolute references, a type of cell reference that always refers to cells in a specific location. For more information about absolute references, type absolute reference in the Office Assistant or on the Answer Wizard tab in the Excel Help window, click Search, click the topic About cell and range references, scroll to the section More information about references, and then click the jump More information about relative and absolute references.