Show Value from Sheet if Cells in Two Ranges are not Blank

[Legacy 48831]

I am working with a spreadsheet that I need to return a calculated value from another spreadsheet only if the values in 2 ranges are not blank. I am not looking to calculate if the values are blank, only see if the cell contains no value and if any cell in the two ranges are blank I want the result in the total cell to be blank otherwise return the value from the other cell in the other sheet.

Basically I have 2 ranges, D15:D27 and H15:H27, if any one of these cells are blank, I want the value in D29 to be blank. Once all of these cells in both ranges are equal to or greater than zero, I want D29 to show the value of the sheet "Fields" cell L36.

Can anyone give me any ideas? I have searched but cannot seem to find the answer.

 

[mumps]

Place this formula in D29: =IF(COUNTBLANK(D15:D27)+COUNTBLANK(H15:H27)>0,"",Fields!F36)

 

[Legacy 48831]

Awesome! That worked perfectly. Thank you so much for your help. I was getting to the hair pulling out stage.

 

[mumps]

You are very welcome.