View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CatPEG CatPEG is offline
external usenet poster
 
Posts: 6
Default n=? in each column

I want to determine the number (n) of entries (each is a number: 0-5) in each
column
(Rows 2 to 143, Columns B through K)

The formula I used to get a total for Column B: =COUNT(B2:B143)
gives me an answer in Row 144 that says there are 43 entries.

However, if I manually count the number of entries, the answer is 44.

Same thing happens for Column C: formula answer is 60, but my manual count
of data entries is 71.

What am I doing wrong? I will appreciate any help you can give me!