CountIf and Search
Hi guys me again :D
I have a set of columns say
incident number summary Assignee
118487 **ASG** 1
118456 ASG 1
115337 ASG - Test 2
115674 bobs ASG 3
123585 test 1
116897 drum 2
123585 ASG 1
OK now i want to do a count statement that will search the Summary for
anything with ASG in it so it needs to count **ASG** and ASG - Test etc as
the same thing but also only out it if it has a match to the assignee field
so say count all ASG for assignee 1
so in this i need it to return the value 3 in the above example
|