cell counter using COUNTIF

[rosh@excel]

hey i want to count the number of cells within the range A2:A200 where value equals to 3001

for exaple call values are as follows

A2 3001
A3 3001
A4 4001
A5 5001
-
-
A200 3001

and i used "countif" function but i got syntax error, can anyone advice me for the correct code.

Please Login or Register  to view this content.

thanks

[watersev]

hi there,

Please Login or Register  to view this content.

[watersev]

seems to be a duplicate post with: http://www.excelforum.com/excel-prog...n-satisfy.html

[rosh@excel]

yes i thought of posting my concern as a new, since old post is very complected and hard to understand for others.

anyway thanks for the advice

and if i want to include the range as the whole column of A, how can i mention it. because the range cannot be define every time as it changes from time to time.

thanks

[watersev]

if the data is on the active sheet:

Please Login or Register  to view this content.

If non-activesheet you need to add sheet reference before range and cells in the line above

[rosh@excel]

yes it worked, thanks.