SUMPRODUCT not working - what is wrong?

[Camel123]

Hi,

I want the formula in Sheet1 to sum total sales for all months per customer per order.

Column B in both sheets= customer number. Column E in both sheets= order number. Q5-AG280= sales per month per customer and order and range to be summed.

{=SUMPRODUCT(('Sheet2'!B:B='Sheet1'!B4)*('Sheet1'!E:E='Sheet1'!E4)*('Sheet2'!Q5:AG280))}

Tried the formula above but not working, any tips?

 

[Repush]

did some checking . . you do need the *
try

[COLOR=#333333]=SUMPRODUCT(--(B5:B10=B5)*--(E5:E10=E5)*Q5:AG10)[/COLOR]