You may have Excel's calculation mode set to Manual...

Try this:

From the Excel main menu:
<tools<options<calculation tab
Check: Automatic

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"adminsecretary" wrote:

i'm modifying a template that I downloaded to track attendance. I want to
track the total days sick, vacation, comp, and personal.My formulas for
Countif look fine(=COUNTIF(B9:AF9,"S"))

but they only compute after I click on the formula bar then press enter. My
problem is that I want to track all the changes automatically. Is there
something that needs to be done as far as formatting? Right now my cells are
formatted as General.