NOT= in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OR in a SUMPRODUCT formula 9
SUMPRODUCT formula - help! 5
Internally assigned List or Tablename of Auto-Filter? 1
Formula is to long 8
What does using -- in a formula do? 8
SUMPRODUCT() challenge - How to integrate a string value in lieu of a value in a cell ..... 3
Segregating Duplicate Transactions 3
Text in a formula 2

Back
Top