How do I correct error using the =IF(AND(formula in excel?

R

Redwing ML

Thank you again for the help but, it must be me? Iam still trying to get your
suggestion to work completely.

Needed=IF(B1:B4,">=01/01/06"),THENCOUNT,(C1:C4,IF=A1))

Your way =SUMPRODUCT(--(B1:B10>=DATE(2006,1,1)), --(A1:A10=C1:C10))does
count but, if i change the actual date in a cell from B to be less than the
date of 2006,1,1 the quantity does not adjust?

Can you help again??

Thanks
 
Top