Quote Originally Posted by FlameRetired View Post
I may be lost, too, but as I interpret, this formula in I2 and filled down:
Formula: copy to clipboard 
=COUNTIF($A2:$H2,"*Communication*")-COUNTIF($A2:$H2,"*Information*")

Results look like this:

Row\Col
A
B
C
D
E
F
G
H
I
J
1
Subject
Dept
Subject
Dept
Subject
Dept
Subject
Dept
2
 Information and Communication
1
 Communication
1
 Progress
2
 Development
1
1
3
 Progress
2
 Development
2
 Progress
1
0
4
 Development
2
 Information and Communication
2
 Progress
2
0
5
 Information and Communication
1
 Communication
2
 Development
2
1
6
 Communication
1
 Development
2
1
7


Does this do what you want a net count?
No, I need the formula to return the value in the column to the right of where "Communication" appears without the string "Information". So, for example, A6 meets the criteria therefore I need the formula in I6 to return the value in B6.

Thanks anyway.