Try SUMIF, i.e.
=SUMIF(D15:D21,1,F15:F21)
you only need to put quotes around the 1 if data in D15:D21 is text
rather than numeric
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=559256