Prev: counting the number of occurences
Next: conditional formatting and coloring cells.
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" <Sam(a)discussions.microsoft.com> 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 occurences
Next: conditional formatting and coloring cells.