HELP!
I need an array that will COUNT the number of occurrences of multiple
criteria across two columns.

Example:
So, in the simplified example below, it would only COUNT occurrences
that are either ['Red' OR 'Amber'] AND '[Ripe', 'Ready' or 'Cooked'].
So far, I've only been able to come up counting it of it's Red or
Amber, but don't know how to incorporate the OR function for the other
criteria set.

The code so far: *=SUM(IF((H10:H215="Amber")+(H10:H215="Red"),1,0)) *
HOW CAN I GET IT TO ALSO CONSIDER THE SECOND SET OF FILTERING
CRITERIA??

_FRUIT_ _COLOUR_
Ripe Red
Inedible Red
Ripe Amber
Rotten Amber
Picked Amber
Ready Red
Cooked Green
Cooked Red
Rotten Yellow


--
AustraliaPosted via http://www.officehelp.in - <a href="http://www.officehelp.in">Microsoft Office Software</a>