count without repeting with 2 conditions

[sarinky]

Hi Everyone,

Just a moment ago, I got my thread solved on "Count without repeting with condition"

http://www.excelforum.com/excel-form...condition.html

I was unable to reply the post, I don't know why.

Now I am trying to adjust the formular with 2 conditions, for example:

Col A: Names of Items want to count (count no repetition)
Col B: Colour of Items
Col B: Quantity

So, I want to count name of Item if QTY=2 and its color is Red (for example).
How can I come up with the formular?

Kind Regards,
Sarin

[icestationzbra]

do you mean Colour of Items in Column B and Quantity in Column C? you have repeated Column B above...

you could possibly extend the ARRAY formula this way:

Please Login or Register  to view this content.