When you have data on multiple worksheets and want to consolidate that data into a summary worksheet, you can use a $3-$D formula. A $3-$D formula is a formula that references the same cell or range of cells across multiple worksheets in a workbook. In the Spa workbook, you will summarize the number of hours and total charges for all three therapists on a new summary worksheet.

On the HoursSummaxy worksheet, in cell B$7,$ create a $3-$D formula that totals cell C$7$ of the Istas, through Niese worksheets. Copy the formula through cell range B$7$:B$24.$

On the HoursSummary worksheet, in cell C$7,$ create a $3-$D formula that sums cell E$7$ of the Istas, through Niese worksheets. Copy the formula through cell range C$7$:C$24.$