SUMPRODUCT help again!
 

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

SUMPRODUCT help again!
 

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

SUMPRODUCT help again!
 

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

SUMPRODUCT help again!
 

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

SUMPRODUCT help again!
 

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