Multiple conditions formula

Could you explain how you arrive at 3 for your example given there are no records that meet your criteria.

Please also outline:

a) which version of XL you are using

b) whether more than 1 "colour" may exist for any given combination

Per your other thread regards cross posting

http://www.mrexcel.com/forum/showthread.php?t=501999

Those who repeatedly cross post without providing links invariably have their posting rights suspended - and in general those persons will be largely ignored by those who frequent the on line communities most.

Originally Posted by Dohko

Isnt this a different forum?

Yes - that is rather the point.

If you spent 30 minutes of your lunch break helping someone resolve a problem only to discover later that someone else unknown to you at the time had fixed the same problem 5 minutes after you had started - wouldn't you be a little displeased at having had your time wasted ?

Please think about your actions - do not abuse the good nature of those willing to assist you (for free).