While initially it may seem complicated, calculating formulas across multiples pages in Excel is actually quite simple. When you create a formula within a single worksheet you enter cell references in the formula. For example, to get a sum for cells A1 and B1 you enter the formula =SUM(A1:B1). To create a formula that crosses multiple pages you just need to include a worksheet reference in addition to the cell reference. When you refer to the same cell or range of cells across multiple worksheets, Microsoft calls this a “3-D reference.” Tips Warnings Writer Bio
