Thread: Formula problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
denise denise is offline
external usenet poster
 
Posts: 112
Default Formula problem

I done that - it doesn't help.

"Elkar" wrote:

Check to make sure the numbers on that sheet are formatted as numbers, and
not text.

HTH,
Elkar


"Denise" wrote:

I am trying to do a simple formula and it won't work.

I have about 2500 rows with a column that has the persons age. I am trying
to do a "countif" the age is < = 2, greater than 2, greater than 6, etc. The
formula has worked every time with every sheet that I open except for one.
The formula is correct it is just giving me 0's and I know that is not
correct.

What is going on?