Formula wierdism

[lecxE]

I have the following formula in cell M938:

=COUNTIF(M2:M937,222)+COUNTIF(M2:M937,333)+COUNTIF(M2:M937,888)

M938 has the value of 607 which is the correct count of my 3 codes.

If I click in the formula bar for the above formula and hit enter without changing anything, cell M938 changes to the literal text of the formula, i.e. "=COUNTIF(M2:M937,222)+COUNTIF(M2:M937,222)+COUNTIF(M2:M937,888)"

If I press ctrl-~ my other formulas toggle between displaying the formula result & displaying the formula. Cell M938 remains as the text.

If I copy the formula in M938 & paste it as is in M939, it shows the value. Is this an Excel bug?

Thanks.

 

[Domski]

Make sure that the cell containing the formula is not formatted as text.

Dom

 

[lecxE]

Doh, I think that was it. Thanks.