sumproduct and sumif

  • Thread starter Thread starter Boris75
  • Start date Start date
B

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?
 
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
 
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
 
Back
Top