Correction ( I had formula slighly worng):

Both solutions are correctly showing "" when nothing in B & nothing in D:J,
however, it is also not showing nothing when nothing in B but D:J adds up to
7 This
should produce the Alert.


"Steve" wrote:

Both the LEN & the Text solutions are close, but not totally correct.
The LEN ic correctly showing "" when nothing in B & nothing in D:J, however,
it is also not showing nothing when nothing in B but D:J adds up to 7 This
should produce the Alert.

The Text is correctly showing the Alert when nothing in B and D:J adds up
to 7, however, also showing Alert when nothing in B and nothing ib D:J. This
should be "".

Thanks,



"Elkar" wrote:

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