I just tried it, and did not have any problems. Note, you don't need the +
sign in the formula. I made D31 the result of a vlookup (that returned a
value that was in the d3:d11 range, and I used a different format for e20
than the format used in e3:11 and got the expected result.

=SUMPRODUCT(--($D$3:$D$11 = $D31),--($E$3:$E$11 = E$20),($F$3:$F$11))
--
Kevin Vaughn


"TMF in MN" wrote:

You guys helped me with this formula yesterday, but still have a question
=+SUMPRODUCT(--($D$3:$D$11 = $D31),--($E$3:$E$11 = E$20),($F$3:$F$11))

If D31 is a VLOOKUP formula, will the SUMPRODUCT formula recognize D31 as a
value?

E20 is a date. If E20 and Array e3:e11 are not formatted the same, will the
SUMPRODUCT formula see them as separate values?

Thank you SO SO SO much!
TMF