You can use the SUMPRODUCT
=SUMPRODUCT((A2:A100=40)*(B2:B100="COMP"))

Adjust ranges/values as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jboo" wrote:

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