SUMPRODUCT FORMULA

[donny]

Can anyone tell mw what's wrong with my formula, I only
have one cell in column L that is greater than 1 yet it is
counting everything that is advised. Thanks

=SUMPRODUCT(((('Shipping Report'!G2:G20000="Advised")*
('Shipping Report'!C2:C20000>=Breakdown!A1)*('Shipping
Report'!C2:C20000<=Breakdown!C1)*('Shipping Report'!
L2:L20000>=1))))

 

[donny]

The rest of the cells in column L do not have any values
only formulas.

 

[Bob Phillips]

That's a shame, because that aside, it seems okay for me.

 

[Ddaannb]

hi!
unless 4 "(" , you can try ... like this :
=SUMPRODUCT(('Shipping Report'!G2:G20000="Advised")*
('Shipping Report'!C2:C20000>=Breakdown!A1)*('Shipping
Report'!C2:C20000<=Breakdown!C1)*('Shipping Report'!
L2:L20000>=1))