I have the following excel worksheet formula:

=COUNTIFS(Inputfile_InQQR!$B$2:$B$5123,"=" & Summary_InQQR!A2,Inputfile_InQQR!$W$2:$W$5123,"Yes",Inputfile_InQQR!$F$2:$F$5123,"Random",Inputfile_InQQR!$AA$2:$AA$5123,"Data Error",Inputfile_InQQR!$C$2:$C$5123,IF((Summary_InQQR!C2="Overall"),"<>" & """",IF((Summary_InQQR!C2)="ABC","ABC","XYZ")))

I am trying to convert this to a vba formula........my issue is with the "IF" statement that i have inside the countifs function.............not sure how to handle this.

I am using in vba the "Application.WorksheetFunction.CountIfs" to duplicate the formula. However, like i said i am not sure how to handle the "IF" statement inside the countifs.

any ideas?