htukaram New Member Sep 26, 2017 #1 dear sir please solve this Attachments DONT COUNT FORMULA.xlsx 18.3 KB · Views: 4
N NARAYANK991 Excel Ninja Sep 26, 2017 #2 Hi , See the attached file. Narayan Attachments DONT COUNT FORMULA.xlsx 19.3 KB · Views: 4
N Naresh Yadav Active Member Sep 26, 2017 #3 Hi, Pls try this one =COUNTIFS($B$2:$B$600,$G3,$C$2:$C$600,"<>"&"FRN") regards Naresh