And() and Or() don't like arrays much. From what I can tell of the formula,
you're trying to sum column E when the following criteria are met:

column H is not equal to "x"
column c + 30 is less than today's date
column d = the value in d77

If that's the case, it should work without the AND function like so:

=sumproduct(--($H$6:$H$66<"x"),--($C$6:$C$66+30<today()),--($D$6:$D$66=d77),$E$6:$E$66)

If I misinterpreted anything in there, please let me know.

--
Mike Lee
McKinney,TX USA


"mjones" wrote:

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