can I use sumproduct, concatenate text and sum column? Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

Not sure why you need concatenate - the sumproduct function, if it
works, will return a single number.

Unless you are using XL2007, you cannot use full-column references
with sumproduct.

Can you explain in words what you are trying to achieve?

Pete

On Aug 13, 2:29*pm, Boris75 wrote:
can I use sumproduct, concatenate text and sum column? *Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

try this
'=SUMPRODUCT(--(data!B2:B22=E5-D5),data!H2:H22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Boris75" wrote in message
...
can I use sumproduct, concatenate text and sum column? Here's what I
wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

Maybe you should describe what you are trying to do, it is hard to derive
from your formula

Also unless you are using 2007 you cannot use B:B or H:H you need to specify
the range



This might work if I interpreted your post correctly


=SUMPRODUCT(--(B1:B100=INDIRECT("E5")&" - "&INDIRECT("D5")),H1:H100)

replace the cell references with what you actually got



--


Regards,


Peo Sjoblom

"Boris75" wrote in message
...
can I use sumproduct, concatenate text and sum column? Here's what I
wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

=SUMIF(B:B,E5&"-"&D5,H:H)


"Boris75" wrote:

can I use sumproduct, concatenate text and sum column? Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

This did work...thank you for your quick response.

"Teethless mama" wrote:

=SUMIF(B:B,E5&"-"&D5,H:H)


"Boris75" wrote:

can I use sumproduct, concatenate text and sum column? Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?

You're Welcome!

"Boris75" wrote:

This did work...thank you for your quick response.

"Teethless mama" wrote:

=SUMIF(B:B,E5&"-"&D5,H:H)


"Boris75" wrote:

can I use sumproduct, concatenate text and sum column? Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?