Unforunately that did not work. The result of [If (sum(G4:K4)1,"","Blank")]
is (Blank) for every row.

"John" wrote:

Try If (sum(G4:K4)1,"","Blank")

John


"Johnny" wrote:

=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.