Let’s take a look.
Referencing cells on other sheets is very similar toreferencing cells on the same sheet.
Start with an equal sign, and then move to the sheet you want to reference.
In this case, we’re just going to build a simple link to the scores in Week1.
Sheet names always appear with an exclamation point at the end, before the cell reference.
To complete the formula, there’s no need to go back to the original sheet.
Now let’s copy this formula down.
you might see that the formula is picking up all the test scores in Week1.
You might wonder what happens to the formula if we change the sheet name?
Luckily, this is not something you’re gonna wanna worry about.
If I temporarily change the name, Excel simply adjusts the formulas.
I’ll change it back now.
For Week2, let’s bring in the reference in a different way withPaste Special.
Now we have a full set of formulas that reference the test scores in Week2.
I know that the first cell reference is D6 because all sheets have the identical structure.
Now I can just copy the formula down.
I’ll do the same thing for Weeks 4 and 5.
Once I add the single quotes, I can enter the formula.
