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 , here i was applying double match but i cant. Here sharing sheet example with you guys please help.
When i use simply countifs formula it works but want to make this formula independent of column name by using 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)), "*")
- Thank you its working, can i not apply index match too for chhattisharh!H3:H1000 column to get match A2
- 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)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*"}))
