Page 51 - Excel Data Analysis

03 537547 Ch02.qxd 3/4/03 11:47 AM Page 37

ORGANIZE WORKSHEET DATA 2

You use the Function field to specify the method by
which Excel combines your data into one worksheet.
Excel provides several different consolidation
functions for merging data:
FUNCTION DESCRIPTION
Sum Adds values between the merged ranges.
Count Counts the number of values in the merged ranges.
Average Averages the values in the merged ranges.
Max Finds the maximum value in the merged ranges.
Min Finds the minimum value in the merged ranges.
Product Multiplies values and returns the result.
Count Nums Counts the number of numeric values in the merged ranges.
StdDev Estimates the standard deviation of the values in the merged ranges.
StdDevp Calculates the standard deviation of the values in the merged ranges.
Var Estimates the variance of the values in the merged ranges based upon a
sampling of the values in the range.
Varp Calculates the variance of the values in the merged ranges using all
values in the range.

Sum

SELECT THE RANGE › Click the Collapse Dialog ■ The Consolidate dialog box ˇ Click the tab of the
TO CONSOLIDATE button. collapses to display only the worksheet containing the
■ If you do not have the Reference field. data to merge.
worksheet containing your
range open, you can click CONTINUED
Browse to open it.
37