=SUMPRODUCT((A1:A1000=40)*(B1:B1000={"COMP","OUTST ","ABOVE"}))


--
__________________________________
HTH

Bob

"Jboo" wrote in message
...
Hello, I need help with a counting criteria I have in two different
columns.
For example I need to know how many "40"'s from column A are Comp or OUTST
or
Above and so on from Column B, then how many "83"s are COMP or OUTST or
ABOVE
and so on. I have used the CountIf function but it will only do the first
criteria.
A B
43 COMP
83 COMP
83 COMP
40 COMP
43 COMP
40 COMP
40 OUTST
40 ABOVE
40 NEDVL
83 UNSAT