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).
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)
=COUNTIFS(Chhattisgarh!N:N,"Okay",Chhattisgarh!I:I,B3)+COUNTIFS(Chhattisgarh!N:N,"Try",Chhattisgarh!I:I,B3)