errors in a simple formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem getting correct totals of a column. I put '1' in the cell when a visit is due. All I want to do is total the number of visits due for a given month. I have used =SUM(O1:O101), I get the total '65', when it is acutally 101.
I also used =COUNT(O1:101) and I still get 65.
I did the 'detect & repair', it did not help. Please advise.
 
Hi
maybe some of the '1' are entered as text and not as value. For testing
purpose put the following formula in P1:
=ISNUMBER(O1)
and copy this formula down to P101
It should return 'TRUE' for all entries of '1' in column O. If it
return FALSE for an entry you have to change the format of this cell

HTH
Frank
 
You've probably entered some of the 1's as Text. Make sure your column
is formatted as General or another numeric format. Coerce the Text
"numbers" to real numbers by copying an empty cell. Select the column
and choosing Edit/Paste Special, selecting the Values and Add radio
buttons.
 
Back
Top