Excel VBA countifs worksheetfunction

I am using WorksheetFunction.CountIfs to count records on Sheet2 depending on certain criteria. The code I'm using is: Dim wksdata As Worksheet Dim xyz as String Dim Time as String Set wksdata =