Help with counting two different criterias.
Do you want to count the number of 40 from column A that are Comp in column B
and the number of 40 in column A that are OUST in column B, each of these
retrun
in different cells?
if yes, try this in C2. Assume that your data start from row 2
=SUMPRODUCT(--(A2:A11=40),--(B2:B11="COMP"))
if you want to count 40 in col A that are Comp,Oust,Above
use this
=SUMPRODUCT(--(A2:A11=40),--(B2:B11="COMP"))+SUMPRODUCT(--(A2:A11=40),--(B2:B11="OUTST"))+SUMPRODUCT(--(A2:A11=40),--(B2:B11="ABOVE"))
--
Hope this is helpful
Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.
Thank You
cheers, francis
"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
|