#REF! Error Resolve?

[Guest]

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

 

[Guest]

If you use another clause in your IF statement that precedes what you have,
it should work like you're expecting. Try inserting:

=IF(COUNTA(A4:B4)<2,"",YOUR_STATEMENT)

YOUR_STATEMENT is what you already have.

HTH

 

[Guest]

Thanks much! That did it!