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