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
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

CU​

[/th][th]

CV​

[/th][th]

CW​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

60​

[/td][td]

0.0​

[/td][td]

0.0​

[/td][td][/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

61​

[/td][td]

0.0​

[/td][td]

0.0​

[/td][td][/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

62​

[/td][td]

0.0​

[/td][td]

0.0​

[/td][td=bgcolor:#D9D9D9]

Overall Totals =​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

63​

[/td][td][/td][td][/td][td]Check Hours[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

64​

[/td][td][/td][td][/td][td] Formula goes here [/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Min[/td][/tr][/table]

 

[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)