formula won't calculate unless I click cell

G

Guest

I am using a countif function in MS Excel. It is counting the instances that
a particular date/ time occurs in a list. The function references the
criteria in an adjacent cell as follows

In cell A2:
9/1/06 5:00 PM

In cell B2:
=countif( D2:D30,A2)

The countif function won't calculate until I double click on cell A2 which
puts a cursor in it and then hit enter on my keyboard. Any ideas on why I
have to click the referenced cell to get the formula to calculate?
 
G

Guest

Do you have calculation set to automatic? Tools-->Options-->Calculation.
Make sure automatic is checked.
 
G

Guest

Do you have calculation set to automatic? Tools-->Options-->Calculation.
Make sure automatic is checked.
 
G

Gord Dibben

Tools>Options>Calculation.

Make sure you are set to "Automatic"


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Tools>Options>Calculation.

Make sure you are set to "Automatic"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate cell reference 2
Another rounding issue 2
Formula for next day based on clock 2
formulas won't calculate 1
looking for a formula 5
How do I create an if function with 9 variables and 6 multipliers? 3
Excel won't calculate my formulas correctly. 2
how to overwrite a value without loosing the formula? 10

Top