You can use a matrix formula to check conditions and sum when conditions are
true.
{=SUM(IF(ISERROR(SEARCH("ASG";B2:B8));0;1)*(D2:D8= 1))}

"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