Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF for 2 conditions | Excel Worksheet Functions | |||
countif two conditions | Excel Discussion (Misc queries) | |||
COUNTIF Statement with Multiple Conditions in Different Ranges | Excel Worksheet Functions | |||
COUNTIF with two conditions | Excel Worksheet Functions | |||
How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions |