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

=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)

"Christopher Naveen" wrote in
message ...
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

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


Change to suit your needs

Regards,
Ryan---



--
RyGuy


"Bob Phillips" wrote:

=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)

"Christopher Naveen" wrote in
message ...
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