Use SUMIF function

=SUMIF(Source range,criteria,sumrange)

e.g. SUMIF(A1:A6,1,B1:B6)

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=520978