If I do this:

=ADDRESS(4,MATCH(E37,A2:JW2,0))

I get:

$L$4

If I do:

=SUMIF(A3:JW3,"Units",ADDRESS(4,MATCH(E37,A2:JW2,0 )):JW4)

I get an error. However if I do:

=SUMIF(A3:JW3,"Units",INDIRECT(G1):JW4)

I get the answer I want. However, I'd prefer to not have a helper cell.

Please help!