multiple range in SUM,IF

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

=SUM(IF(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H75>31<=93),('13b'!F3:F75),""))

Im above array formula, 3rd criteria i am trying to set range > 31 AND <=93
but it doesnt work .. could anyone help ??
 
=SUMPRODUCT(('13b'!A3:A75="Customer1")*('13b'!C3:C75="QAR")*('13b'!H3:H75>31)*('13b'!H3:H75<=93),('13b'!F3:F75))

Check whether the A3:A75 criteria is "Customer1" or "Customer 1". If it is
Customer 1 then change the A3:A75 criteria in the formula also. Since there
was an unfortunate Paragraph Mark in your post, so I could not able to
identify.

Remember to Click Yes, if this post helps!
 
Back
Top