sumproduct and sumif

[Boris75]

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?

 

[Pete_UK]

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

 

[Don Guillett]

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

 

[Peo Sjoblom]

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

 

[Teethless mama]

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

 

[Boris75]

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

 

[Teethless mama]

You're Welcome!

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