..............................code1.........code2. .........code3
tom.............................................1
dick.............................................. ..................1
tom............................................... .................1

=sumproduct((A2:A100="tom")*(B2:B100=1))+sumproduc t((A2:A100="tom")*(c2:c100=1))+sumproduct((A2:A100 ="tom")*(d2:d100=1))

this gives you how many jobs tom has done

if you set up a matrix with names down the first column and codes as
column headers, you can reference these in the sumproduct formula, so
just one formula can be copied to the whole of the table. You then can
see a summary of who has done which jobs.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=569391