Think you need sumproduct
Try the below
=SUMPRODUCT(--(D1:D8="Red")*(C1:C8<"delete"))
Link attached for more on Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=561761