View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Naveen[_2_] Christopher Naveen[_2_] is offline
external usenet poster
 
Posts: 58
Default Countif Function

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