Transpose formula returning #N/A in certain cells where values in source data is blank

[howard]

I have the following transpose formula which is an array

 =-TRANSPOSE('C:\downloads\[BR1.xlsm]Summary'!$C$3:$L$3)

Where the cells on sheet "summary" C:L are blank , then the formula returns #N/A


I have tried using iferror, but get the same result


It would be appreciated if someone could amend my formula so that if any of the cells in the source data are blank, a blank will be returned

 

[howard]

I have also posted on

https://www.excelforum.com/excel-fo...lues-in-source-data-is-blank.html#post5182675

 

[howard]

Problem resolved. I did not select entire source range in my formula