Here is what I have that works fine:
What I want is for this to count all records that not only meet these criteria, but not just 'Awaiting Approval' in column G but also 'First Call', 'Second Call'.
Code:
NotMarked = Application.WorksheetFunction.CountIfs(Range("G6:G20000"), "Awaiting Approval", Range("D6:D20000"), "Routine")
Worksheets("Sheet1").TextBox1.Value = NotMarked & " Tests"
What I want is for this to count all records that not only meet these criteria, but not just 'Awaiting Approval' in column G but also 'First Call', 'Second Call'.