=SUMIF(A1:B5,C1,B1:B5)
A1:B5 is the range
C1 is the Crieteria
B1:B5 adds up the numbers that meet the criteria


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517306