=$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?
You can try using 3D cell references.
For example, if you want to sum the contents of column J on all three sheets you can use the formula:
Creating a Name for your 3D Reference
This will make it easier for you to reference the columns.
To sum the contents of column J in
Not all Excel formulas can accept 3D references. Here are the ones that do: