Formula ?

[zone709]

i use this formula below

=SUM(C62:CV62)-(CX62)

It checks hour totals from where it starts. This formula is always under the name Check Hours and ends above that word Before Overall Totals=. What I am trying to do is every time I shift the 2 columns to go to the next which will be CW & CX . I have to change CV62 to CX62. Is there a way it can do that in a formula to change CV to the column before the work Overall Totals= at all times?

Excel 2016 (Windows) 32 bit

	CU​	CV​	CW​
60​	0.0​	0.0​
61​	0.0​	0.0​
62​	0.0​	0.0​	Overall Totals =​
63​			Check Hours
64​			Formula goes here

Sheet: Min

 

[Legacy 386498]

Try this:

=SUM(INDIRECT("C62:"&ADDRESS(62;COLUMN()-1)))-(CX62)

 

[zone709]

Cant get it to go. I keep trying different things

 

[Legacy 386498]

That's weird, it works over here. Can you share your file? (delete everything confidential first)

 

[Yongle]

Perhaps it's the comma / semi-colon "local formula" issue

try

=SUM(INDIRECT("C62:"&ADDRESS(62​,COLUMN()-1)))-(CX62)