COUNT Incidences of Specific Text within column referencing multiple rows

[Skittlebeanz]

Hi,

I hope someone can help as I'm a little stuck on how to approach this one.

I would like to know if there is a way I can count the number of times a specific text occurs within a column but by anchoring this only to those rows which match a certain code in the far left column.

I have a large spreadsheet to which I need to apply this but have attached a simplified example of the problem.

So, in this example, how can I return how many Oranges are 'Good' or how many Apples are 'Bad'?

A slick and fast formula would help as I need to calculate around 300,000 rows and do so for around 90 column headings.

Is there a way to do this?

Any help would be really appreciated.

Thanks