I am brain dead...I cannot remember how to count value in one column if
another coulmn meets a certain criteria.
For instance
I want to count all the "NO" in columns D & E, but only if column B is Annex

Heather Annex Business Services NO NO
Enedina Stock Storekeeper 1 NO
Thomas JCW Operator 0 1
Arnold Fuel Fuel Handling 0 0
David K12 Maintenance 0 NO
Eric K12 Operator 0 0
Gary K12 Maintenance 0 NO
Tammy K12 Maintenance 0 NO
Chris JCW Maintenance 1 NO
Frank K34 Maintenance 1 NO
Craig Fuel Fuel Handling 0 1
Kenneth JCW Technical Business 0 NO
Alfredo JCW Operator 0 0
Michael JCW Maintenance 0 NO
Kurt K12 Operator 1 1
Tara Stock 0 NO
Mark Fuel Fuel Handling 0 0
Lukus Fuel Fuel Handling 0 1
Marty Annex Business Managers 0 0

--
Krista