Domenic Wrote:
Try...

=SUMPRODUCT((Sheet1!A1:A100=Sheet2!B11)*Sheet1!C1: F100)



thanks so much for your quick reply! I gave it a try, but I'm getting a
#value! error. any thoughts on how I might fix that?


--
mminsf
------------------------------------------------------------------------
mminsf's Profile: http://www.excelforum.com/member.php...o&userid=24767
View this thread: http://www.excelforum.com/showthread...hreadid=383325