Counting Problem

Guys I have a problem.

I will explain it with fruits.

I want to count the oranges (each of the rows is in one excel cell)

apple,orange
orange
banana,orange,apple
apple, banana
banana
apple

I know that i could seperate the data, but as I am dealing with a huge dataset and I dont want to do this.
COUNTIF() does not work for counting the oranges, it will only give back 1.

Thanks Guys

Thank you very much for your reply,

I have tried it, but there is a problem.

to be more specific, I am doing a failure analysis. If I use =COUNTIF(A:A;"*CORROSION*"), the function will pick every cell that has the word corrosion in it, but I need to distinguish here further as there is "Corrosion General", "Corrosion Localized", "Corrosion Pores" etc

an example with fruits would look like this:

Orange big,Orange small
Apple, Orange big
Orange big
Orange small, Banana
Banana, Orange big

How to count the big Oranges?

Like Sambo Kid said, just add "big":
=Countif(A:A,"*orange big*")

thanks,
seems that I stated my problem a little bit wrong. I am sorry.

Let me please try it again:

Orange big, Orange small
Apple, Orange big
Orange big, Orange
Orange
Banana, Orange big
Orange, Orange big


I want to count just "Orange" (not "Orange big" and not "Orange small").

If I use now =COUNTIF(A:A;"*Orange*") I will get back 6. But there are only 3 "Orange". How can I do that?

Might this work?
=COUNTIF(A:A,"*orange")+COUNTIF(A:A,"orange,*")
The second COUNTIF uses the fact that all the words in the cell are separated by a comma.

Thank you,

that worked out