View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gareth - Network analyst. Gareth - Network analyst. is offline
external usenet poster
 
Posts: 21
Default 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