Forum Discussion
Countifs
Hi guys, Please help me in countifs formula to count *text* in a column with current date and one more criteria is with specfic row name. I was trying to write countifs formula with index match ...
In K2:
=SUM(COUNTIFS(Chhattisgarh!$H$3:$H$1000, $A2, INDEX(Chhattisgarh!$Q$3:$ZZ$1000, 0, MATCH(K$1, Chhattisgarh!$Q$2:$ZZ$2, 0)), {"*cnp*", "*cnc*"}))
Thank you so much!! Suggest me how can i clear my formula concept like u... It will be honour for me to get a teacher or mentor like you