Forum Discussion
Formula sheet increment
I have a sheet that takes the total sum from other sheets cell U48. My current formula is =‘001’!U$48. I have to create a totaling sheet that will reference U48 from sheet 001-100. How do I create a...
In special cases you can use 3d references which basically allow you to sum across sheets:
=SUM('001:100'!U$48)
=SUM('001:100'!U$48)