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?

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?