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:
=COUNTIFS(Chhattisgarh!$H$3:$H$1000, $A2, INDEX(Chhattisgarh!$Q$3:$ZZ$1000, 0, MATCH(K$1, Chhattisgarh!$Q$2:$ZZ$2, 0)), "*")
One more query : can yoy please convert this formula also to with index match and with two different text count in a different way
I am using this currently : =COUNTIFS(Chhattisgarh!Q:Q,"*cnp*",Chhattisgarh!$H:$H,$A2)+ COUNTIFS(Chhattisgarh!Q:Q,"*cnc*",Chhattisgarh!$H:$H,$A2)
I am using this currently : =COUNTIFS(Chhattisgarh!Q:Q,"*cnp*",Chhattisgarh!$H:$H,$A2)+ COUNTIFS(Chhattisgarh!Q:Q,"*cnc*",Chhattisgarh!$H:$H,$A2)
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*"}))
HansVogelaar Hi Hans, i used this formula as you put here, but the result is only doing sum for "cnp" , not for "cnc"
Even if the tag of your post is "Excel for web", you use Google Sheets. They are working differently. Some functions not compatible, some give the same result, some give different results.
- 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
