sumproduct and sumif
 

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?

sumproduct and sumif
 

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?

sumproduct and sumif
 

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?

sumproduct and sumif
 

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?

sumproduct and sumif
 

=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?

sumproduct and sumif
 

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?

sumproduct and sumif
 

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?