AHHHHHHHHHHHHHH :D thanks again :D it worked :D just got to add a value to
look up against :D

thanks Richard

"RichardSchollar" wrote:

Gareth

So on sheet2 you want something like:

=SUMPRODUCT((Sheet1!$C$2:$C$8=Sheet2!
$A2)+0,ISNUMBER(SEARCH("ASG",Sheet1!$B$2:$B$8))+0)

copied down?

Richard


On 9 Mar, 12:11, Gareth - Network analyst.
wrote:
Arg ok problem 2 now

same columns but

Incident+ (column 1)
112123
213123
546213
789456
546213

Summary+ (column 2)
**ASG**
ASG
ASG - BOB
test
dump

Assignee+ (column 3)
Gareth Thompson
Gareth Thompson
Bob Dilan
Ross Flake
Gareth Thompson
Gareth Thompson

All this information is on Sheet 1. Now my control sheet is on sheet2

So my sheet two looks like this.
Gareth Has - (formula in next cell) - ASG calls
Bob Dilan - (formula in next cell) - ASG calls
Ross Flake - (formula in next cell) - ASG calls

Now having Sumformula and Sum wont work right??? or how would i do this???