View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?