View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
len len is offline
external usenet poster
 
Posts: 53
Default count formula problem

I have a formula in excell to count the amount of cells that contain numbers.
I use this formula =COUNT(A1:A90) and if the count was 30 I would get 31. I
have two other sheets in the same file where the calculations are correct.

The only way I can get the correct calculation is to do this formula
=COUNT(A1:A90)-1

Any ideas?