The count function is not working

S

smita

Forgive me if I've posted this twice. My connection cut off in the middle of
my earlier posting. As an attempt to learn how create graphs, I deliberately
created a set of data in which I know for a fact that the value "4" was
entered 5 times in cells A1-A20. However, when I typed in "=COUNT (A1:A20,
4), the number 6 was returned to me. I know this is an error, so what am I
doing wrong and how can I fix this problem.

Thanks.
 
P

Peo Sjoblom

Try

=COUNTIF(A1:A20,4)

what yout formula does is counting all the numeric values
in A1:A20 plus one (the 4 after the comma)

Regards,

Peo Sjoblom
 
A

Ashish Mathur

Hi,

Use the counif function instead. Count is not a conditional function

Regards,

Ashish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loose formula/value (when building graphs) 3
COUNTING THE SAME VALUES IN A SHEET 3
count function is inaccurate 2
Count of Font Format 1
Formulas Still Not Working 5
Function for summing or counting cells based on a specified fill color 3
count if equal to not working? 1
How to count a range of number to a given parameter or criteria. 4

Top