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.

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

"Franz Verga" wrote:

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

That was the problem. Thank you, I learned something new!!

Nothing to do with format which determines is how data is displayed
Sounds like you need to use Tools | Options; open the Calculation tab and
set calculations to Automatic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"adminsecretary" wrote in message
...
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.

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.