Thank you Bernard and Shane. Yes, I do want it to count how many "NO"'s.
That way we know how many classes they have not completed. I appreciate your
help...sooooo much.
--
Krista


"ShaneDevenshire" wrote:

Hi,

Based on your data I would ask one question - if a row has the word Annex
and has No in column D and E do you count that as 1 or 2 No's?

If two, than the formula would be like Bernards:
=SUMPRODUCT((D1:E19="No")*(B1:B19="Annex"))
If once, then the formula would be:
=SUMPRODUCT(--(((D1:D19="No")+(E1:E19="No"))*(B1:B19="annex")1) )


--
Thanks,
Shane Devenshire


"Kristamarie" wrote:

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