Counting till the current value

[tutu10]

I want to count till the current cell and I used the following formula:

In cell K61(Row 61), I entered COUNTIF(B5:B61, "<>C")

There are over a thousand such cells where I need this formula. If I copy & paste the formula onto other cells the range changes. What to do ?

 

[arthurbr]

Try =countif(B$5:INDEX(B:B,MATCH(REPT("Z",255),B:B)),"<>"&"C")