consolidate function
Improving Performance in Excel 2007 On the Data tab, in the Data Tools group, click Consolidate. In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM. Following is an example with three worksheet ranges selected.