count number of times cell value changes by formula

[vijayamani1987]

Hi people,

I come across some similar posts but not able to modify it to my purpose.

In column C & F has if function, D&E has sum function. The formula in C:C is =IF(AND(M4>=3,N4>=2,O4="wait"),"wait",IF(AND(M4<=-3,N4<=-2,O4="close"),"close","-")). These values in D,E and F keeps changing for every 15 minutes and so C column. I want the number of times "wait" or "close" arrived in C column to be recorded in A & B column.

	A	B	C	D	E	F
1	Wait	Close	(if function)	(sum function)	(sum function)	(if function)
2
3			wait	3	5	wait
4			-	1	4	close
5			close	-5	-3	close
6			-	1	-6
7			-	4	9
8			-	-3	-7	wait
9			close	-6	-4	close

<colgroup><col span="3"><col><col span="3"><col></colgroup><tbody>
</tbody>

Any help appreciated.

<colgroup><col span="4"><col span="3"><col></colgroup><tbody>
</tbody>

<colgroup><col span="4"><col span="3"><col></colgroup><tbody>
</tbody>

<colgroup><col span="4"><col span="3"><col></colgroup><tbody></tbody>

 

[RasGhul]

Copy across from A to B

=COUNTIF($C:$C,A1)