The
purpose of creating these Defined Names is to use the references in
a formula. The following pages will demonstrate how to
conditionally summarize data with formulas.
A
Conditional Summary means: show me the data that matches my
Criteria. At the basic level, a Conditional Summary is a filter.
Say you had three products: legs, eggs and pigs. A filter asks: show
me the eggs sales. A Conditional Summary asks: show me the
eggs sales that were greater than $500.00 per day. Which days? 1. Try
This: Create a Sample Formula
Select Cell F1 and type: Sample Formula
Select Cell F2.
Go to
Formulas ->Defined Names.
Go to Use in Formula.
Select:
Revenue.
2. What Do You See? The formula is: =Revenue.
The formula bar displays the Defined Name and the
correct Range of Cells is selected.
Please UNDO this practice and keep going...
Formulas ->Defined Names Use in Formula ->Use
in Formula
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.3. Data summary: SUMIF, SUMIFS,
COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS |
|
| |
