Hi All,

This function works:

=SUMPRODUCT(AND(($H$9<"x"),($C$9+30<TODAY()))*($D $9=D77),$E$9)

But when I update it to this one, it gives a $0 result and there
should be a number.

=SUMPRODUCT(AND(($H$6:$H$66<"x"),($C$6:$C$66+30<T ODAY()))*($D$6:$D
$66=D77),$E$6:$E$66)

or

{=SUMPRODUCT(AND(($H$6:$H$66<"x"),($C$6:$C$66+30< TODAY()))*($D$6:$D
$66=D77),$E$6:$E$66)}

Any ideas would be much appreciated?

Michele