First make sure calcualation mode is set to automatic.

Second.......if you are in edit mode when you hit F9 the formula will
disappear.


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 10:47:01 -0800, andylea16
wrote:

The following formula:


=COUNTIF(X8:X17,"*7*")+COUNTIF(X24:X35,"*7*")+COU NTIF(X43:X75,"*7*")

will only return a value when Calculate Now is selected, then the formula
disappears.

I need the formula to return the value and update as changes are made to the
worksheet.


AR