Try this:

=IF(AND(LEN(C3)0,L3<5),"Alert","")

HTH,
Elkar


"Steve" wrote:

I have 1's or 0's in row 3 , D E F G H I J
Col L sums D:J
If the sum of D3:J3 does not = 5 (col L), I want an "alert" in K3, such as:
=IF(L3<5,"Alert","")

However, I also need it to additionally refer to another cell (C3)

Something to the effect: If there is text in C3, (maybe C30 ??), and the
above "Alert' would be in K3, then give me that ALERT, but, if there is
nothing in C3, even if the "Alert' would be produced in K3 because of the
above formula, I don't want the "Alert". I want nothing "".

Thanks,

Steve