=$J:$J references an entire column on the current sheet while
='Sheet2'!$J:$J references that entire column on
Is there a way to reference column
J on all sheets without manually typing all the sheet names?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
You can try using 3D cell references.
Select the column that you want to reference. You'll end up with something like this:
For example, if you want to sum the contents of column J on all three sheets you can use the formula:
This will make it easier for you to reference the columns.
To sum the contents of column J in
Sheet3, you just have to use this formula:
Not all Excel formulas can accept 3D references. Here are the ones that do: