Summing columns on a different sheet using numerical column number

[rjheibel]

Using a match function, I have identified the column number I would like to sum through : =MATCH('Current Month'!H1,'Baseline '!A1:AQ1,0)

Now I would like to create the sum statement =B3+(SUM('Baseline '!H4:L4)) but I would like the end of the range "L" to be based on the result of the formula above which is 12.

Any help is much appreciated!

 

[dfsobral]

you could use indirect function

B3+(SUM(INDIRECT( "'Baseline '!H4:L" & MATCH('Current Month'!H1,'Baseline '!A1:AQ1,0) )))

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I would also recommend removing the space character at the end of the 'Baseline ' sheet tab. Trailing (& leading) spaces often lead to errors/problems.

The requirement is also slightly unclear to me in that your MATCH function starts looking in column A but your SUM function starts at column H.
However, my reading of the question is that you may want one of these.

=B3+SUM('Baseline '!H4:INDEX('Baseline '!H4:AQ4,MATCH('Current Month'!H1,'Baseline '!A1:AQ1,0)))

=B3+SUM('Baseline '!H4:INDEX('Baseline '!H4:AQ4,MATCH('Current Month'!H1,'Baseline '!A1:AQ1,0)-7))

I would also be interested to know the name of the worksheet this formula is in?

 

[Peter_SSs]

Thanks for updating your version details.
Looks like one of those formulas must have been what you are after ...
.. but I am hoping you would also be able to respond to my question:

I would also be interested to know the name of the worksheet this formula is in?