No, you can do that

=SUMPRODUCT((B2:B110&D2:D110=B114)*(E2:P110))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Barb Reinhardt" wrote in message
...
Bob,

Let's say I want to concatenate B2 with D2 and compare it to B114, what do
I
change? Or do I need to have a helper column?

=SUMPRODUCT((D2:D110=B114)*(E2:P110))

"Bob Phillips" wrote:

=SUMPRODUCT((D2:D110=D112)*(E2:P110))