Thanks @Pecoflyer for your solution. generally it works but it losses its count when i add text to OP id. sometimes text is required to be mentioned along with ID number.


Also im trying to figure out if can how many OP is present in a individual "A" group (A1 to A12 M/C), then "B" group (B1 to B12 M/C). I cant give cell range like AK8:AK30,AK8:AK30 , because A1 to A12 M/C range will vary. sometimes it will be AK8:AK38 or AK8:AK25 or AK8:AK42 etc.

It needs to be somthing like this " =SUMIFS(AK:AK,AK:AK,C:C,C:C,"A*") "

Attached Files

TEST COUNT 2.xlsx (31.0 KB, 4 views)