The formula below will produce the #REF! Error in cell L4 until data is input
in cells A4 and B4. Once data is input, the #REF! error will go away, and be
replaced with a numerical outcome of 0 or 1.

Is there an addition to the formula below which I can use to just leave the
cell "blank" until the data is input in A4 and B4. I just hate seeing that
#REF! Error!

=IF(AND(SUMPRODUCT(--(rnga<""),--(rngb<""),--(rnga=$A4),--(rngb=$B4))1,C4<"x"),1,0)

Thanks,

Dan