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 ...
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
=ArrayFormula(SUM(COUNTIFS(INDIRECT($A3&"!I:I"),B3,INDIRECT($A3&"!N:N"),{"*Okay*","*Try*"})))
This is working