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

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
 
T

Tom [Pepper] Willett

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
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with counting two different criterias. 9
SumIf with OR criteria 5
How do I match values in a sub set after a sort? 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 3
Cumulative formula for word table 0
How to center adjust text above and image in a two column document. 1
Need Help with Macro Security 1
Blank result, want a zero 2

Top