i assume they all need to equal b11 and if so then add them up
try this

where a1:a26 is your sum range

=SUMIF(A1:A26,B11,A1:A26)


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549415