Hello, I need help with a counting criteria I have in two differen

  • Thread starter Thread starter Jboo
  • Start date Start date
J

Jboo

Hello, I need help with 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
 
Please post in an Excel newsgroup..this is for FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Hello, I need help with 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
:
 
Back
Top