Count cells with different values

[cabete]

Hello everyone.
I am trying to make a formula but i am not successful until now.

What i am try.
I want count the number of changes over on a plant. This value from C1 ,C2, C3 are came from a combobox are can be from 1 to 25

I will give a example:

C1 "1"
C2 "1"
C3 "1"

This ( Means i don't have changeovers and the line are not planned)

If i have :

C1 "2"
C2 "1"
C3 "1"

I have 1 changeover.

If i have :

C1 "2"
C2 "4"
C3 "1"

I have 2 changeover.

Can someone help me to do a formula, i have try the countif(C1,C2) but this just count if they are equal.

Already try =IF(COUNTIF(C1:C3,C1:C3)=3,0,IF(COUNTIF(C1:C3,C1:C3)=1,2,1)) but not give what i want.
Any subjection???

 

[Aladin Akyurek]

Try...

=SUMPRODUCT(1-(C1:C2=C2:C3))

 

[cabete]

Sorry my mistake when i has translating.

will give a example:

C1 "1"
C2 "1"
C3 "1"

This ( Means i don't have changeovers and the line are not planned)

If i have :

C1 "2"
C2 "1"
C3 "1"

I have 0 changeover.

If i have :

C1 "2"
C2 "4"
C3 "1"

I have 1 changeover.

If i have :

C1 "2"
C2 "4"
C3 "10"

I have 2 changeover.

 

[Aladin Akyurek]

Is it

=SUMPRODUCT(1-(C1:C2=C2:C3))-1

then?

 

[cabete]

No there is not what i want.

 

[cabete]

See this example:

http://s000.tinyupload.com/?file_id=327 ... 7913288996