COUNTIF 2 conditions
I am trying to write a formula that would say count number of cells with
traumatic and overuse injuries by body part based on sample data below
A B C
1 Sam head trauma
2 Joe neck overuse
3 Mary shoulder overuse
4 Sam shoulder trauma
5 Henry head overuse
6 Carlos neck overuse
Results should look like this
A B C
1 Trauma Overuse
2 Head 1 1
3 neck 0 2
4 Shld 1 1
The following formulas do not work: =COUNTIF(b1:b6,A2)+COUNTIF(c1:c6,b1)
COUNTIF(b1:b6,A2)*ANDCOUNTIF(c1:c6,b1)
|