MMM,

Try,

=SUMIF(B2:B1000,4122,C2:C1000)

or

=SUMPRODUCT((A2:B1000=4122)*(C2:C1000))

Adjust the 4122 as needed for different inspectors.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561171