View Single Post
  #1   Report Post  
Sojo
 
Posts: n/a
Default 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)