Forum Discussion
Countifs
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.
Does it help if you confirm the formula by pressing Ctrl+Shift+Enter?
Thank you so much , its working with cntrl + shift+ enter.
And i applied the same formula to count and sum two crietria "okay" and "Try" then its not working. Sharing screenshot with you.
I'd have to see a copy of the workbook (without sensitive data).
