Countif Function

[Christopher Naveen]

Hi

I have a data as mentioned below can u pls tell me how can we count a
particular No. in a column.

Ex : 658
657
658
666
658

Now I want to count how many 658's and how many 666's are ther in the column.

Ans : 658 = 3
666 = 1

Can anyone help me how can we apply the formula to get the result.

Thanks in Advance!!!!

-Christ

 

[Bob Phillips]

=COUNTIF(A:A,658)

=COUNTIF(A:A,666)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ryguy7272]

Something like this:
=SUMPRODUCT(--((A1:A100)=658))


Change to suit your needs

Regards,
Ryan---