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)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"
- Thank you its working, can i not apply index match too for chhattisharh!H3:H1000 column to get match A2
