=SUM(IF(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531)*('13b'! H3:H75<=93),('13b'!F3:F75),""))
as an array formula
or (not an array formula) either
=SUMPRODUCT(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531)*('13b'! H3:H75<=93)*('13b'!F3:F75))
or
=SUMPRODUCT(--('13b'!A3:A75="Customer
1"),--('13b'!C3:C75="QAR"),--('13b'!H3:H7531),--('13b'!H3:H75<=93),('13b'!F3:F75))
--
David Biddulph

"Sam" wrote in message
...
=SUM(IF(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531<=93),('1 3b'!F3:F75),""))

Im above array formula, 3rd criteria i am trying to set range 31 AND
<=93
but it doesnt work .. could anyone help ??