Nel post
*adminsecretary* ha scritto:

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.

Check that Calculation is Automatic: menu Tools, Options, tab Calculation,
select the radiobutton Automatic.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy