=IF(G4:K41,"","BLANK")

Above is the formula that I am using but unfortunately it keeps returning a
(#VALUE!) result. With in the (G-K) array there are fomulas that have results
that are blank.

As i copy this formula to each row in columb L some of the cells within the
(G-K)array will have some result of 1 though 6.