office 2007 -- formulas

A

andylea16

The following formula:


=COUNTIF(X8:X17,"*7*")+COUNTIF(X24:X35,"*7*")+COUNTIF(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
 
G

Gord Dibben

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
 
Top