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 ...
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).
- Hey Hans i got the solution,
=ArrayFormula(SUM(COUNTIFS(INDIRECT($A3&"!I:I"),B3,INDIRECT($A3&"!N:N"),{"*Okay*","*Try*"})))
This is working - Hi, actually i want to use this formula in a simpler way
=COUNTIFS(Chhattisgarh!N:N,"Okay",Chhattisgarh!I:I,B3)+COUNTIFS(Chhattisgarh!N:N,"Try",Chhattisgarh!I:I,B3)