HI!

I was looking earlier for something very similiar.

What you are probable going to use is a Array Formula.

This is a sample of what I think will do it:

=SUM(IF($D$12:$D$15="blue",IF($E$12:$E$15<DATEVALU E("1/5/2003"),1,0),0))

If you have the add-in, Conditional Sum would suffice.