How to count type of the point?

[onohong]

Dear All,

I have several points that need to count it but I don't know how to do it with formula?

Here is the attachment for detail.....

[samba_ravi]

D3=COUNTIF($A$2:$A$57,C3)

Please Login or Register  to view this content.

Try this and copy towards down

[onohong]

The Result is 0. How to deal with it?

[JohnTopley]

in order of your list in the file

=SUM(IF(ISNUMBER(A2:A57),1))

=SUM(IF(ISNUMBER(SEARCH("/",A2:A57,1)),1))-SUM(IF(ISNUMBER(SEARCH("P",$A$2:$A$57,1)),1))

=SUM(IF(ISNUMBER(SEARCH("P",$A$2:$A$57,1)),1))

=SUM(IF(ISNUMBER(SEARCH("A",$A$2:$A$57,1)),1)) .... counts those ending A

=SUM(IF(ISNUMBER(SEARCH("-",A2:A57,1)),1)) .... those having "-" but will include "A" & "-"

Enter all formulas with Ctrl+Shift+Enter

[onohong]

Big big thank to you. You are my saver.....

[JohnTopley]

Appreciate the feedback. Please mark the thread as SOLVED. Thank you.

[onohong]

Hi Another question, Do you have any idea how to classify the type of points that I just ask you above?

-Type A; 12/2, 12-2, 40, 42, 245 in this type there are no duplicate or the same value.
-Type B; 46/6(1), 46/6(2), 45(1), 45(2) in the type there are duplicate value but the number 1 and 2 inside the bracket indicated that it is in type B.
-Type C; 21/1(1), 21/1(2), 21/1(3) it is just like type B but number 1, 2 and 3 inside the bracket indicate that it is in type C.

I have the attachment for more detail about it.

Thanks

[onohong]

Hi I forget to tell one more point in type 1 like 236(1) and 236(2). So how to solve it?