Hi Jim,

try...

=SumIf(C2:C4,"=10",B2:B4)
=SumIf(C2:C4,"=5",B2:B4)

Obviously adjusting the C2:c4 and B2:B4 ranges to suit!

HTH

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=397129