SUMPRODUCT FORMULA

  • Thread starter Thread starter donny
  • Start date Start date
D

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