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))
--
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

What do you suggest? It is returning a #N/A error to me.


"Kevin Vaughn" wrote:

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

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.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515448

OUTSTANDING!!!!! I hadn't thought of that!



"daddylonglegs" wrote:


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.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515448