SUMPRODUCT help again!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
If you're getting #N/A that probably means you have #N/A in one of your
ranges, if you can eliminate that then it should work.
 
Back
Top