Mar 24 2023 04:34 AM
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
Mar 24 2023 05:04 AM
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)), "*")
Mar 24 2023 05:41 AM
Mar 24 2023 05:44 AM
Mar 24 2023 06:01 AM
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*"}))
Mar 24 2023 12:34 PM
Mar 24 2023 01:51 PM
Mar 25 2023 08:30 PM
@Hans Vogelaar Hi Hans, i used this formula as you put here, but the result is only doing sum for "cnp" , not for "cnc"
Mar 26 2023 03:18 AM
Does it help if you confirm the formula by pressing Ctrl+Shift+Enter?
Mar 26 2023 06:32 AM
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.
Mar 29 2023 04:28 AM
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.
Mar 29 2023 04:55 AM
I'd have to see a copy of the workbook (without sensitive data).
Mar 29 2023 10:21 AM
Mar 29 2023 10:23 AM