From: Sam on 16 Dec 2009 01:06 =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 ?? From: "David Biddulph" groups [at] on 16 Dec 2009 01:34 =SUM(IF(('13b'!A3:A75="Customer 1")*('13b'!C3:C75="QAR")*('13b'!H3:H75>31)*('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:H75>31)*('13b'!H3:H75<=93)*('13b'!F3:F75)) or =SUMPRODUCT(--('13b'!A3:A75="Customer 1"),--('13b'!C3:C75="QAR"),--('13b'!H3:H75>31),--('13b'!H3:H75<=93),('13b'!F3:F75)) -- David Biddulph "Sam" wrote in message news:ED1FB426-6D9D-41DF-BE3B-E904FAEF7B8D(a)microsoft.com...> =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 ?? From: Ms-Exl-Learner on 16 Dec 2009 01:54 =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! -------------------- (Ms-Exl-Learner) -------------------- "Sam" wrote: > =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 ??  |  Pages: 1 Prev: counting the number of occurencesNext: conditional formatting and coloring cells.