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