NOT= in a formula
The symbol for not equal to is: <
Hope this helps.
Pete
Kierano wrote:
I am using the following formula to work out when we have a status of red
against work programmes:
=SUMPRODUCT(--($B$2:$B$191="Prog1"),--($C$2:$C$191="Prog2"),--($D$2:$D$191="RED"))
However, I want to introduce a further criteria which picks up when a plan
is not in place. Excel doesn't seem to like it when I add NOT = "Active" to
the end of the above formula.
Anyone got any ideas please?
|