| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
office 2007 -- formulas
The following formula:
=COUNTIF(X8:X17,"*7*")+COUNTIF(X24:X35,"*7*")+COUN TIF(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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
office 2007 -- formulas
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Install Office Standard XP on Vista. Uninstall Office 2007 Trial? | Excel Discussion (Misc queries) | |||
| Viewing formulas for Print in Microsoft Office 2007 | Excel Worksheet Functions | |||
| Since updating Office 2003 to 2007 Excel formulas do not work? | Excel Discussion (Misc queries) | |||
| Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Hybrid Mode
