» Nesting Formulas in Excel 2007

To combine functions into one long nested power Formula:

1. Insert the following formula into cell C12:
=SUMIF(TB_DB_Level3,A12,H:H)
2. Insert the following formula into blank cell :
= OFFSET(TB_DB_Level3,0,MonthSelectionNumber+2)
3. Select cell containing the OFFSET function (see step 2 above), In the Formula Bar select the formula without the equal (=) symbol, and press Ctrl+C to copy.
4. Click Cancel or Enter (the two buttons between the Name Box and the fx button on the left of the Formula Bar) to exit edit mode.
5. Select the cell containing the SUMIF function (cell C12), and in the Formula Bar, select the reference H1, and press Ctrl+V to paste.