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*") "
Last edited by stricky; 05-18-2024 at 10:20 PM.
Reason: adding a querry
|