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