Hi

Assuming those values are in A1:C8 (headers in A1) then you cn use:

=SUMPRODUCT(($C$2:$C$8=1)+0,ISNUMBER(SEARCH("ASG", $B$2:$B$8))+0)

Hope this helps!

Richard



On 9 Mar, 10:42, Gareth - Network analyst.
wrote:
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