dynamic named range across columns

[amartino44]

Hello. I am trying to make this formula dynamic across the columns.

(Actuals!$BP$9:$BP$10,Actuals!$BP$13:$BP$15,Actuals!$BP$19,Actuals!$BP$31:$BP$35,Actuals!$BP$39:$BP$40,Actuals!$BP$43:$BP$45,Actuals!$BP$49,Actuals!$BP$52:$BP$58,Actuals!$BP$61:$BP$65,Actuals!$BP$70:$BP$74,Actuals!$BP$78:$BP$80,Actuals!$BP$87:$BP$91,Actuals!$BP$122,Actuals!$BP$153:$BP$157,Actuals!$BP$163:$BP$167


This is the formula that I tried using but it is not working. Any reasons why? Thanks.

=Offset(Actuals!$BP$9:$BP$10,Actuals!$BP$13:$BP$15,Actuals!$BP$19,Actuals!$BP$31:$BP$35,Actuals!$BP$39:$BP$40,Actuals!$BP$43:$BP$45,Actuals!$BP$49,Actuals!$BP$52:$BP$58,Actuals!$BP$61:$BP$65,Actuals!$BP$70:$BP$74,Actuals!$BP$78:$BP$80,Actuals!$BP$87:$BP$91,Actuals!$BP$122,Actuals!$BP$153:$BP$157,Actuals!$BP$163:$BP$167,0,0,Count($BP:$BP),Count($1:$1))

[mikeTRON]

As always, you are much more likely to get a response if you post a sample dataset.

[amartino44]

That wouldn't add any value to the post. It would be a worksheet with those two formulas lol. It's essentially non-contiguous named range, and I want to make it dynamic with additional columns but the formula isn't working.