C
CatPEG
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!
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!