Using Transpose Function with Indirect & Row Function

Does anyone know if or how I can use the Indirect & Row functions with the Transpose function?
It appears Excel does not allow this as I get an error when I try to enter the following:

TRANSPOSE(INDIRECT("'Construction Cost Assumptions'!"&"$AR"&ROW()):INDIRECT("'Construction Cost Assumptions'!"&"$BK"&ROW()))

The existing formula, without using the Indirect & Row functions is below.

SUMPRODUCT(OFFSET('SFD Pricing & Unit Sales'!$B$929,MATCH(Model_1_Name,'SFD Pricing & Unit Sales'!$B$929:$B$1166,0),MATCH(F$2,'SFD Pricing & Unit Sales'!$2:$2,0)-2,COUNTA('General & Market Assumptions'!$E$65:$E$84),1)*(TRANSPOSE('Construction Cost Assumptions'!$AR$9:$BK$9)>0))*INDIRECT("'Construction Cost Assumptions'!"&"$N"&ROW())

However, because the row number can change for the data in the Construction Cost Assumptions
worksheet, I really need a method that will allow me to use the Transpose function or replace it
with something would accomplish the same thing. Any recommendations would be greatly appreciated.

Attached is an example spreadsheet.

There are instructions at the top of the page explaining how to attach your SAMPLE workbook. This should be a small, desensitised version. Thanks.